Skip site navigation (1) Skip section navigation (2)

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: 2009-11-27 11:51:33
Message-ID: 4B0FBD45.7080203@2ndquadrant.com (view raw or flat)
Thread:
Lists: pgsql-performance
Richard Neill wrote:
> Or am I barking up the wrong tree entirely?
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.

-- 
Greg Smith    2ndQuadrant   Baltimore, MD
PostgreSQL Training, Services and Support
greg(at)2ndQuadrant(dot)com  www.2ndQuadrant.com


In response to

Responses

pgsql-performance by date

Next:From: Faheem MithaDate: 2009-11-27 21:47:37
Subject: Re: query optimization
Previous:From: Ron MayerDate: 2009-11-27 04:49:47
Subject: Re: RAID card recommendation

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group