Re: Bad Plan for Questionnaire-Type Query

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

On Fri, May 8, 2009 at 10:00 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2009-05-09 15:52:05 Re: Bad Plan for Questionnaire-Type Query
Previous Message Laurent Wandrebeck 2009-05-09 09:43:05 Re: Slow select performance despite seemingly reasonable query plan