On Thu, Oct 21, 2010 at 1:51 AM, Samuel Gendler
> 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.
In response to
pgsql-performance by date
|Next:||From: Gael Le Mignot||Date: 2010-10-21 12:25:44|
|Subject: Periodically slow inserts |
|Previous:||From: Samuel Gendler||Date: 2010-10-21 07:51:21|
|Subject: Re: Index scan is not working, why??|