On Thu, Oct 21, 2010 at 1:51 AM, Samuel Gendler <sgendler@xxxxxxxxxxxxxxxx> wrote: > please provide non-default config options on this host plus the same from a > host which is using an index scan, please. Also, postgresql version, OS, > and all of the other stuff that is asked for in this > document: http://wiki.postgresql.org/wiki/SlowQueryQuestions. It is > impossible to say why the query planner might be choosing a particular plan > without any insight whatsoever as to how the server is configured. I know it's mentioned in that wiki doc, but the ddl for the table and its indexes, or the output of \d tablename is quite useful and should be included as well. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
