Postgres Pro
Downloads
Home   >   mailing lists

Re: query produces 1 GB temp file - Mailing list pgsql-performance

From Greg Stark
Subject Re: query produces 1 GB temp file
Date
Msg-id 876515k7er.fsf@stark.xeocode.com
Whole thread Raw
In response to query produces 1 GB temp file  (Dirk Lutzebaeck <lutzeb@aeccom.com>)
Responses Re: query produces 1 GB temp file
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Gaetano Mendola
Date:
Subject: Re: horizontal partition
Next
From: Jan Wieck
Date:
Subject: Re: PostgreSQL clustering VS MySQL clustering