Statistical Analysis - Mailing list pgsql-general

From Nathan Barnett
Subject Statistical Analysis
Date
Msg-id 71975481CD04D4118E57004033A2596E0DF947@ip205.82.136.216.in-addr.arpa
Whole thread Raw
List pgsql-general
I am having to perform a large data analysis query fairly frequently and the
execution time is not exceptable, so I was looking at doing a statictical
sample of the data to get fairly accurate results.  Is there a way to
perform a query on a set number of random rows instead of the whole dataset?
I have looked through the documentation for a function that would do this,
but I have not seen any.  If this is a RTFM type question, then feel free to
tell me so and point me in the right direction because I just haven't been
able to find any info on it.

Thanks ahead of time.


---------------
Nathan Barnett


pgsql-general by date:

Previous
From: Dave Smith
Date:
Subject: Only updating part of a column
Next
From: "Mitch Vincent"
Date:
Subject: Re: Statistical Analysis