> 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 )
In response to
pgsql-performance by date
|Next:||From: Pavan Deolasee||Date: 2008-03-25 12:23:58|
|Subject: Re: increasing shared buffer slow downs query performance.|
|Previous:||From: Alvaro Herrera||Date: 2008-03-25 12:01:01|
|Subject: Re: what is the maximum number of rows in a table inpostgresql 8.1|