Postgres Pro
Downloads
Home   >   mailing lists

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

From Christopher Kings-Lynne
Subject Re: query produces 1 GB temp file
Date
Msg-id 4209D489.8090402@familyhealth.com.au
Whole thread Raw
In response to Re: query produces 1 GB temp file  (Dirk.Lutzebaeck@t-online.de (Dirk Lutzebaeck))
List pgsql-performance
Tree view 
> 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

pgsql-performance by date:

Previous
From: Dirk.Lutzebaeck@t-online.de (Dirk Lutzebaeck)
Date:
Subject: Re: query produces 1 GB temp file
Next
From: Alex
Date:
Subject: How can I make use of both CPUs in a dual processor machine