Postgres Pro
Downloads
Home   >   mailing lists

Re: Is it require further tuning - Mailing list pgsql-performance

From Robert Haas
Subject Re: Is it require further tuning
Date
Msg-id AANLkTinr1RZzy0S0t3aY7wfa9sjYxj6rh5Z2xxPKqPj5@mail.gmail.com
Whole thread Raw
In response to Is it require further tuning  (Adarsh Sharma <adarsh.sharma@orkash.com>)
List pgsql-performance
Tree view 
On Wed, Mar 2, 2011 at 11:31 PM, Adarsh Sharma <adarsh.sharma@orkash.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

pgsql-performance by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Slowing UPDATEs inside a transaction
Next
From: Landreville
Date:
Subject: Calculating 95th percentiles