Quick Links

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-07 22:56:35
Message-ID:	9d1f8d830905071556q1ecbb496m98d3509a80429b5@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-performance

On Thu, May 7, 2009 at 6:44 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Look into pg_stats for the rows concerning the columns used in the
> query's WHERE and JOIN/ON clauses.

Okay, here you go:
http://rafb.net/p/20y8Oh72.html

David

In response to

Re: Bad Plan for Questionnaire-Type Query at 2009-05-07 22:44:13 from Tom Lane

Responses

Re: Bad Plan for Questionnaire-Type Query at 2009-05-09 00:08:30 from Tom Lane

Browse pgsql-performance by date

	From	Date	Subject
Next Message	Tom Lane	2009-05-07 23:06:56	Re: Indexes not used in DELETE
Previous Message	Tom Lane	2009-05-07 22:44:13	Re: Bad Plan for Questionnaire-Type Query