Postgres Pro
Downloads
Home   >   mailing lists

Re: Bad Plan for Questionnaire-Type Query - Mailing list pgsql-performance

From David Blewett
Subject Re: Bad Plan for Questionnaire-Type Query
Date
Msg-id 9d1f8d830905071028s6ae5bdf5v8649090a3b3adf8b@mail.gmail.com
Whole thread Raw
In response to Bad Plan for Questionnaire-Type Query  (David Blewett <david@dawninglight.net>)
Responses Re: Bad Plan for Questionnaire-Type Query
List pgsql-performance
Tree view 
On Thu, May 7, 2009 at 12:53 PM, David Blewett <david@dawninglight.net> wrote:
> 1. http://dpaste.com/hold/41842/
> 2. http://explain.depesz.com/s/Wg
> 3. http://explain.depesz.com/s/1s
> 4. http://dpaste.com/hold/41846/

Forgot to mention that I'm using Postgres 8.3.6 on linux 2.6.24.
Shared buffers are set to 1GB, effective_cache_size is set to 3GB.
Server has 6GB RAM, running on a SCSI 4-disk RAID10.

David Blewett

pgsql-performance by date:

Previous
From: David Blewett
Date:
Subject: Bad Plan for Questionnaire-Type Query
Next
From: Scott Carey
Date:
Subject: Re: Transparent table partitioning in future version of PG?