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 9d1f8d830905090815t4c8b27c6p218b7a603fa1359b@mail.gmail.com
Whole thread Raw
In response to Re: Bad Plan for Questionnaire-Type Query  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Bad Plan for Questionnaire-Type Query
List pgsql-performance
Tree view
On Fri, May 8, 2009 at 10:00 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Thanks.  Could I trouble you for one other data point --- about how many
> rows are in each of these tables?

Not a problem:
canvas_dateresponse          263819
canvas_foreignkeyresponse 646484
canvas_integerresponse      875375
canvas_submission              135949
canvas_textresponse           142698

David

pgsql-performance by date:

Previous
From: Laurent Wandrebeck
Date:
Subject: Re: Slow select performance despite seemingly reasonable query plan
Next
From: Tom Lane
Date:
Subject: Re: Bad Plan for Questionnaire-Type Query