Re: Bad Plan for Questionnaire-Type Query

From: David Blewett <david(at)dawninglight(dot)net>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Bad Plan for Questionnaire-Type Query
Date: 2009-05-07 17:28:14
Message-ID: 9d1f8d830905071028s6ae5bdf5v8649090a3b3adf8b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, May 7, 2009 at 12:53 PM, David Blewett <david(at)dawninglight(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Carey 2009-05-07 17:36:58 Re: Transparent table partitioning in future version of PG?
Previous Message David Blewett 2009-05-07 16:53:06 Bad Plan for Questionnaire-Type Query