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
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
