Horton

Re: query produces 1 GB temp file

Greg Stark <gsstark@mit.edu>

View thread
From: Greg Stark <gsstark@mit.edu>
To: lutzeb@aeccom.com
Cc: Greg Stark <gsstark@mit.edu>, pgsql-performance@postgresql.org, tgl@sss.pgh.pa.us, john@arbash-meinel.com
Date: 2005-02-06T15:57:48Z
Lists: pgsql-performance 
I gave a bunch of "explain analyze select" commands to test estimates for
individual columns. What results do they come up with? If those are inaccurate
then raising the statistics target is a good route. If those are accurate
individually but the combination is inaccurate then you have a more difficult
problem.

-- 
greg