From: "Andrus" <kobruleht2@hot.ee>
Subject: Re: Increasing select max(datecol) from bilkaib where
	datecol<=date'2008-11-01' and (cr='00' or db='00') speed
Date: Wed, 12 Nov 2008 20:06:47 +0200
Organization: Hub.Org Networking Services
Lines: 24
Message-ID: <gff602$1ebo$1@news.hub.org>
References: <gff26k$2etc$1@news.hub.org>
	<1d709ecc0811120928n3c183df5kb7b7d50dee6f73ed@mail.gmail.com>
	<alpine.DEB.1.10.0811121730500.4666@aragorn.flymine.org>
Mime-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1";
	reply-type=response
Content-Transfer-Encoding: 7bit
In-Reply-To: <alpine.DEB.1.10.0811121730500.4666@aragorn.flymine.org>
To: pgsql-performance@postgresql.org

Matthew,

Thank you.

bilkaib table contains GL transactions for every day.
00 records are initial balance records and they appear only in start of year 
or start of month.
They may present or may be not present for some month if initial balance is 
not calculated yet.
If 00 records are present, usuallly there are lot of them for single date 
for db and cr columns.
This query finds initial balance date befeore given date.
bilkaib table contains several year transactions so it is large.

>Alternatively if you create an index on (cr, bilkaib) and one on (db, 
>bilkaib) then you will be able to use other values in the query too.

I'm sorry I do'nt understand this.
What does the (cr, bilkaib) syntax mean?
Should I create two functions indexes and re-write query as Vladimir 
suggests or is there better appoach ?

Andrus.