Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Thu, 12 Aug 2004 22:07:45 +0800 (WST)
- Message-id: <20040812220716.J82695-100000@houston.familyhealth.com.au> <text/plain>
> 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
- References:
- Re: [GENERAL] How to know which queries are to be optimised?
- From: Ulrich Wisser
- Re: [GENERAL] How to know which queries are to be optimised?
- Prev by Date: Re: Hardware upgrade for a high-traffic database
- Next by Date: Re: [GENERAL] How to know which queries are to be optimised?
- Previous by thread: Re: [GENERAL] How to know which queries are to be optimised?
- Next by thread: Re: [GENERAL] How to know which queries are to be optimised?
- Indexes: