Postgres Pro
Downloads
Home   >   mailing lists

Indices (was Re: [GENERAL] query seems too slow) - Mailing list pgsql-general

From Holger Klawitter
Subject Indices (was Re: [GENERAL] query seems too slow)
Date
Msg-id 38214D93.288149BA@klawitter.de
Whole thread Raw
Responses Re: Indices (was Re: [GENERAL] query seems too slow)  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
Tree view 
By the way,

I've created a secondary index on a large table in order to
gain some speed (the index is not unique), but the "explain"
did not report any change.

What else do I have to do to actually *use* an index? The manual
only tells how to create one.

FAQ?

Regards,
    Holger Klawitter
--
Holger Klawitter                                     +49 (0)251 484 0637
holger@klawitter.de                             http://www.klawitter.de/

pgsql-general by date:

Previous
From: Stuart Woolford
Date:
Subject: Re: [GENERAL] indexed regex select optimisation missing?
Next
From: Peter Eisentraut
Date:
Subject: Re: [GENERAL] users in Postgresql