Re: [GENERAL] How to know which queries are to be optimised?

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Ulrich Wisser <ulrich(dot)wisser(at)relevanttraffic(dot)se>
Cc: pgsql-performance(at)postgresql(dot)org, <bruno(at)wolff(dot)to>
Subject: Re: [GENERAL] How to know which queries are to be optimised?
Date: 2004-08-12 14:07:45
Message-ID: 20040812220716.J82695-100000@houston.familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-performance

> 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Christopher Kings-Lynne 2004-08-12 14:09:16 Re: [GENERAL] How to know which queries are to be optimised?
Previous Message Tom Lane 2004-08-12 13:58:56 Re: Re: We have got a serious problem with pg_clog/WAL synchronization

Browse pgsql-performance by date

  From Date Subject
Next Message Christopher Kings-Lynne 2004-08-12 14:09:16 Re: [GENERAL] How to know which queries are to be optimised?
Previous Message Merlin Moncure 2004-08-12 13:39:46 Re: Hardware upgrade for a high-traffic database