Re: Is it require further tuning

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Adarsh Sharma <adarsh(dot)sharma(at)orkash(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Is it require further tuning
Date: 2011-03-04 14:55:39
Message-ID: AANLkTinr1RZzy0S0t3aY7wfa9sjYxj6rh5Z2xxPKqPj5@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, Mar 2, 2011 at 11:31 PM, Adarsh Sharma <adarsh(dot)sharma(at)orkash(dot)com> wrote:
> Don't know why it uses Seq Scan on loc_context_terror as i have indexes on
> the desired columns as well.

I don't see how an index scan would help. The query appears to need
all the rows from that table.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Landreville 2011-03-04 15:18:01 Calculating 95th percentiles
Previous Message Merlin Moncure 2011-03-04 14:51:30 Re: Slowing UPDATEs inside a transaction