In article <a55915760804021107h4410dd93m33a6f94e28a83a2b@xxxxxxxxxxxxxx>, "Rodrigo E. De León Plicet" <rdeleonp@xxxxxxxxx> writes: > On Wed, Apr 2, 2008 at 12:36 PM, Alex Solovey <a.solovey@xxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general