Re: query produces 1 GB temp file

From: Greg Stark <gsstark(at)mit(dot)edu>
To: lutzeb(at)aeccom(dot)com
Cc: Greg Stark <gsstark(at)mit(dot)edu>, pgsql-performance(at)postgresql(dot)org, tgl(at)sss(dot)pgh(dot)pa(dot)us, john(at)arbash-meinel(dot)com
Subject: Re: query produces 1 GB temp file
Date: 2005-02-06 15:57:48
Message-ID: 876515k7er.fsf@stark.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Dirk Lutzebaeck 2005-02-06 16:04:05 Re: query produces 1 GB temp file
Previous Message Gaetano Mendola 2005-02-06 15:50:08 Re: horizontal partition