Horton

Re: query produces 1 GB temp file

Christopher Kings-Lynne <chriskl@familyhealth.com.au>

View thread
From: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
To: lutzeb@aeccom.com
Cc: John A Meinel <john@arbash-meinel.com>, Greg Stark <gsstark@mit.edu>, pgsql-performance@postgresql.org, tgl@sss.pgh.pa.us
Date: 2005-02-09T09:14:49Z
Lists: pgsql-performance 
> I'm doing VACUUM ANALYZE once a night. Before the tests I did VACUUM and 
> then ANALYZE.

I'd suggest once an hour on any resonably active database...

Chris