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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

  From Date Subject
Next Message Faheem Mitha 2009-11-27 21:47:37 Re: query optimization
Previous Message Ron Mayer 2009-11-27 04:49:47 Re: RAID card recommendation