| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | Samuel Gendler <sgendler(at)ideasculptor(dot)com> |
| Cc: | AI Rumman <rummandba(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Index scan is not working, why?? |
| Date: | 2010-10-21 07:54:00 |
| Message-ID: | AANLkTim3OpYbaEHXhQ+9dJJPJtKybQ5q+8vuqcnDcG9j@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Thu, Oct 21, 2010 at 1:51 AM, Samuel Gendler
<sgendler(at)ideasculptor(dot)com> 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gael Le Mignot | 2010-10-21 12:25:44 | Periodically slow inserts |
| Previous Message | Samuel Gendler | 2010-10-21 07:51:21 | Re: Index scan is not working, why?? |