Postgres Pro
Downloads
Home   >   mailing lists

Re: index is not used - Mailing list pgsql-novice

From Tom Lane
Subject Re: index is not used
Date
Msg-id 5812.1029855049@sss.pgh.pa.us
Whole thread Raw
In response to index is not used  (mila boldareva <pierro@dds.nl>)
Responses Re: index is not used  (mila boldareva <pierro@dds.nl>)
List pgsql-novice
Tree view 
mila boldareva <pierro@dds.nl> writes:
> But the indices are not used, even when I added a separate index on
> field1 !

Have you run ANALYZE (or VACUUM ANALYZE) on that table?

            regards, tom lane

pgsql-novice by date:

Previous
From: "Darrin Domoney"
Date:
Subject: Event recurrence - in database or in application code ????
Next
From: "Thilo Hille"
Date:
Subject: Re: index is not used