On Mar 23, 2009, at 5:44 AM, Brad Murray wrote:
My current procedure...
1) Create temporary table with each possible data point. This
example uses
recursive functions from pgsql 8.4 but was originally implemented by
using
large numbers of queries from php. My knowledge of the recursive
I'm wanting to optimize and improve a query to get the maximum number of
users over a period of time. What I'm trying to accomplish is to get
graphable data points of the maximum number of simultaneous users at a
specified interval over a period of time, preferably with only a single pass
through