On Wed, Apr 2, 2008 at 1:06 PM, Harald Fuchs <[EMAIL PROTECTED]> wrote: > In article <[EMAIL PROTECTED]>, > > "Rodrigo E. De León Plicet" <[EMAIL PROTECTED]> writes: > > > On Wed, Apr 2, 2008 at 12:36 PM, Alex Solovey <[EMAIL PROTECTED]> wrote: > >> ... I have no idea how it could be fixed. > > > - CREATE INDEX xifoo ON foo(bar_id); > > - ANALYZE; > > - Retry. > > A compound index > CREATE INDEX xifoo2 ON foo (foo_a, bar_id) > might be more worthwhile.
And, if you're only interested in certain values of foo_a or bar_id then partial indexes might be helpful but still cheap enough to maintain in a large table. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
