David Blewett <david(at)dawninglight(dot)net> writes:
> 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:
I got some time to poke into this, but didn't get very far --- the
joins that seem to be the main problem involve
canvas_textresponse.submission_id which you didn't include stats for.
regards, tom lane
In response to
pgsql-performance by date
|Next:||From: Tom Lane||Date: 2009-05-09 00:17:34|
|Subject: Re: PostgreSQL with PostGIS on embedded hardware |
|Previous:||From: Paolo Rizzi||Date: 2009-05-09 00:02:20|
|Subject: Re: PostgreSQL with PostGIS on embedded hardware|