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: (view raw or whole 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 
for an intro.

Greg Smith    2ndQuadrant   Baltimore, MD
PostgreSQL Training, Services and Support

In response to


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-2015 The PostgreSQL Global Development Group