Re: Bad Plan for Questionnaire-Type Query

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: David Blewett <david(at)dawninglight(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Bad Plan for Questionnaire-Type Query
Date: 2009-05-09 02:00:48
Message-ID: 21238.1241834448@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

David Blewett <david(at)dawninglight(dot)net> writes:
> Apparently there was a typo in the query that I didn't notice that
> excluded that table's columns. Here is the new output including it:
> http://pastesite.com/7017

Thanks. Could I trouble you for one other data point --- about how many
rows are in each of these tables?

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Laurent Wandrebeck 2009-05-09 09:43:05 Re: Slow select performance despite seemingly reasonable query plan
Previous Message Craig Ringer 2009-05-09 01:25:38 Re: Transparent table partitioning in future version of PG?