Statistical Analysis

From: "Nathan Barnett" <nbarnett(at)cellularphones(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Statistical Analysis
Date: 2000-07-24 19:20:31
Message-ID: 71975481CD04D4118E57004033A2596E0DF947@ip205.82.136.216.in-addr.arpa
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mitch Vincent 2000-07-24 19:20:53 Re: Statistical Analysis
Previous Message Dave Smith 2000-07-24 19:07:55 Only updating part of a column