Postgres Pro
Downloads
Home   >   mailing lists

Re: postgres not use index, IN statement - Mailing list pgsql-performance

From Craig Ringer
Subject Re: postgres not use index, IN statement
Date
Msg-id 4DDAED36.3030706@postnewspapers.com.au
Whole thread Raw
In response to postgres not use index, IN statement  ("Anibal David Acosta" <aa@devshock.com>)
List pgsql-performance
Tree view 
On 24/05/2011 5:30 AM, Anibal David Acosta wrote:

> So, this is some bug?

Hard to know with the information provided. Please post EXPLAIN ANALYZE
output.

http://wiki.postgresql.org/wiki/SlowQueryQuestions

--
Craig Ringer

Tech-related writing at http://soapyfrogs.blogspot.com/

pgsql-performance by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: "error with invalid page header" while vacuuming pgbench data
Next
From: Robert Haas
Date:
Subject: Re: reducing random_page_cost from 4 to 2 to force index scan