Skip site navigation (1) Skip section navigation (2)

Re: Index scan is not working, why??

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 (view raw or flat)
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.

In response to

pgsql-performance by date

Next:From: Gael Le MignotDate: 2010-10-21 12:25:44
Subject: Periodically slow inserts
Previous:From: Samuel GendlerDate: 2010-10-21 07:51:21
Subject: Re: Index scan is not working, why??

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group