Re: Analyse without locking? - Mailing list pgsql-performance

From Greg Smith
Subject Re: Analyse without locking?
Date
Msg-id 4B0FBD45.7080203@2ndquadrant.com
Whole thread Raw
In response to Analyse without locking?  (Richard Neill <rn214@cam.ac.uk>)
Responses Re: Analyse without locking?  (Richard Neill <rn214@cam.ac.uk>)
List 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@2ndQuadrant.com  www.2ndQuadrant.com


pgsql-performance by date:

Previous
From: Ron Mayer
Date:
Subject: Re: RAID card recommendation
Next
From: Faheem Mitha
Date:
Subject: Re: query optimization