Postgres Pro
Downloads
Home   >   mailing lists

Re: what is the maximum number of rows in a table in postgresql 8.1 - Mailing list pgsql-performance

From sathiya psql
Subject Re: what is the maximum number of rows in a table in postgresql 8.1
Date
Msg-id f966c2ee0803250508t444524b6y44b9ee67c8e04673@mail.gmail.com
Whole thread Raw
In response to Re: what is the maximum number of rows in a table in postgresql 8.1  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: what is the maximum number of rows in a table in postgresql 8.1  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-performance
Tree view


Shows us the explain analyze.  There is no problem with a large number
of records, as long as you're not expecting to process all of them all
the time.
yes many a times i need to process all the records,

often i need to use count(*) ????

so what to do  ?? ( those trigger options i know already, but i wil l do count on different parameters )



pgsql-performance by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: what is the maximum number of rows in a table in postgresql 8.1
Next
From: "Pavan Deolasee"
Date:
Subject: Re: increasing shared buffer slow downs query performance.