Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] How to know which queries are to be optimised? - Mailing list pgsql-performance

From Christopher Kings-Lynne
Subject Re: [GENERAL] How to know which queries are to be optimised?
Date
Msg-id 20040812220716.J82695-100000@houston.familyhealth.com.au
Whole thread Raw
In response to Re: [GENERAL] How to know which queries are to be optimised?  (Ulrich Wisser <ulrich.wisser@relevanttraffic.se>)
List pgsql-performance
Tree view 
> I do a vacuum full analyze every night.
> How can I see if my FSM setting is appropriate?

On a busy website, run vacuum analyze once an hour, or even better, use
contrib/pg_autovacuum

Chris

pgsql-performance by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: Hardware upgrade for a high-traffic database
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: [GENERAL] How to know which queries are to be optimised?