Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Analyse without locking?
- From: Greg Smith <greg(at)2ndquadrant(dot)com>
- To: Richard Neill <rn214(at)cam(dot)ac(dot)uk>
- Cc: PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org>
- Subject: Re: Analyse without locking?
- Date: Fri, 27 Nov 2009 06:51:33 -0500
- Message-id: <4B0FBD45.7080203@2ndquadrant.com> <text/plain>
Richard Neill wrote:
If you haven't already tuned checkpoint behavior, it's more likely that's causing a dropout than autovacuum. See the checkpoint_segments section of http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server for an intro.Or am I barking up the wrong tree entirely?
-- Greg Smith 2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support greg(at)2ndQuadrant(dot)com www.2ndQuadrant.com
- Follow-Ups:
- Re: Analyse without locking?
- From: Richard Neill
- Re: Analyse without locking?
- References:
- Analyse without locking?
- From: Richard Neill
- Analyse without locking?
- Prev by Date: Re: RAID card recommendation
- Next by Date: Re: query optimization
- Previous by thread: Re: Analyse without locking?
- Next by thread: Re: Analyse without locking?
- Indexes: