From: | "Mitch Vincent" <mitch(at)venux(dot)net> |
---|---|
To: | "Nathan Barnett" <nbarnett(at)cellularphones(dot)com>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Statistical Analysis |
Date: | 2000-07-24 19:20:53 |
Message-ID: | 013d01bff5a4$48d518f0$4100000a@doot |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I don't think it's random (well, I'm sure it's not) but you could use LIMIT
to get a smaller number of results...
*shrug* just an idea.
Good luck!
-Mitch
----- Original Message -----
From: "Nathan Barnett" <nbarnett(at)cellularphones(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Monday, July 24, 2000 3:20 PM
Subject: [GENERAL] Statistical Analysis
> 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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Fetter, David M | 2000-07-24 19:36:42 | [General] Problems upgrading from v6.4.2 to v7.0.2 |
Previous Message | Nathan Barnett | 2000-07-24 19:20:31 | Statistical Analysis |