Firstly, please upgrade to Postgres 8.3 if possible.
On Wed, 12 Nov 2008, Andrus wrote:
> There are columns
> kuupaev date, cr char(10), db char(10)
> and regular indexes for all those fields.
Create a single index on (cr, db, datecol).
Those who do not understand Unix are condemned to reinvent it, poorly.
-- Henry Spencer
In response to
pgsql-performance by date
|Next:||From: Vladimir Sitnikov||Date: 2008-11-12 17:28:53|
|Subject: Re: Increasing select max(datecol) from bilkaib where datecol<=date'2008-11-01' and (cr='00' or db='00') speed|
|Previous:||From: firerox||Date: 2008-11-12 17:25:59|
|Subject: Re: slow full table update|