David Blewett <david@xxxxxxxxxxxxxxxx> writes: > On Thu, May 7, 2009 at 4:31 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: >> as few as ten rows out, it'd likely switch to a different plan. So the >> So the question to ask is why the rowcount estimates are so abysmally bad. >> You mentioned having tried to increase the stats targets, but without >> seeing the actual stats data it's hard to speculate about this. > How do I get that data for you? Look into pg_stats for the rows concerning the columns used in the query's WHERE and JOIN/ON clauses. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
