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

From Tom Lane
Subject Re: Bad Plan for Questionnaire-Type Query
Date
Msg-id 21238.1241834448@sss.pgh.pa.us
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  (David Blewett <david@dawninglight.net>)
List pgsql-performance
David Blewett <david@dawninglight.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

pgsql-performance by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Transparent table partitioning in future version of PG?
Next
From: Laurent Wandrebeck
Date:
Subject: Re: Slow select performance despite seemingly reasonable query plan