Postgres Pro
Downloads
Home   >   mailing lists

Re: Increasing select max(datecol) from bilkaib where datecol<=date'2008-11-01' and (cr='00' or db='00') speed - Mailing list pgsql-performance

From Matthew Wakeling
Subject Re: Increasing select max(datecol) from bilkaib where datecol<=date'2008-11-01' and (cr='00' or db='00') speed
Date
Msg-id alpine.DEB.1.10.0811121723560.4666@aragorn.flymine.org
Whole thread Raw
In response to Increasing select max(datecol) from bilkaib where datecol<=date'2008-11-01' and (cr='00' or db='00') speed  ("Andrus" <kobruleht2@hot.ee>)
List pgsql-performance
Tree view 
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).

Matthew

--
Those who do not understand Unix are condemned to reinvent it, poorly.
                -- Henry Spencer

pgsql-performance by date:

Previous
From:
Date:
Subject: Re: slow full table update
Next
From: "Vladimir Sitnikov"
Date:
Subject: Re: Increasing select max(datecol) from bilkaib where datecol<=date'2008-11-01' and (cr='00' or db='00') speed