Re: Statistical Analysis
От | Mitch Vincent |
---|---|
Тема | Re: Statistical Analysis |
Дата | |
Msg-id | 013d01bff5a4$48d518f0$4100000a@doot обсуждение исходный текст |
Ответ на | Statistical Analysis ("Nathan Barnett" <nbarnett@cellularphones.com>) |
Список | 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@cellularphones.com> To: <pgsql-general@postgresql.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 > >
В списке pgsql-general по дате отправления: