re : Slow date comparison

From: <pejac(at)altern(dot)org>
To: pgsql-novice(at)postgresql(dot)org
Subject: re : Slow date comparison
Date: 2001-01-30 15:24:50
Message-ID: 200101301539.f0UFdWq24453@mail.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

First do you update statistics with vaccum ????
Second, execute your query with explain in order to see
if postgresql use index .

For your function do you use the keyword WITH ( ISCACHABLE)
in order to use index for you funtcion ????

Cheers,

PEJAC pascal

Browse pgsql-novice by date

  From Date Subject
Next Message Robert McGinnis 2001-01-30 15:37:59 Re: Best WebInterface...?
Previous Message rudy 2001-01-30 14:37:36 Slow date comparison