re : Slow date comparison - Mailing list pgsql-novice

From
Subject re : Slow date comparison
Date
Msg-id 200101301539.f0UFdWq24453@mail.postgresql.org
Whole thread Raw
List 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

pgsql-novice by date:

Previous
From: rudy
Date:
Subject: Slow date comparison
Next
From: "Marc Zandvliet"
Date:
Subject: truncated numeric data