pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Ron Mayer <rm_pg@cheapcomplexdevices.com>
To: Greg Smith <gsmith@gregsmith.com>
Subject: Re: Background vacuum
Date: Sat, 19 May 2007 15:38:12 -0700
Message-ID: <464F7C54.7090902@cheapcomplexdevices.com> (raw)
In-Reply-To: <Pine.GSO.4.64.0705190100570.29971@westnet.com>
References: <4642A1B3.6030009@swissembedded.com>
	<4642A811.9010703@drivefaster.net>
	<4643B490.2040704@cheapcomplexdevices.com>
	<20070517135530.GI6907@phlogiston.dyndns.org>
	<464D04F8.7020306@cheapcomplexdevices.com>
	<Pine.GSO.4.64.0705172246320.20470@westnet.com>
	<464D18CE.8070408@cheapcomplexdevices.com>
	<18134.1179458524@sss.pgh.pa.us>
	<464DFCC3.8040207@cheapcomplexdevices.com>
	<Pine.GSO.4.64.0705190100570.29971@westnet.com>

Greg Smith wrote:
> 
> Let's break this down into individual parts:

Great summary.

> 4) Is vacuuming a challenging I/O demand?  Quite.
> 
> Add all this up, and that fact that you're satisfied with how nice has
> worked successfully for you doesn't have to conflict with an opinion
> that it's not the best approach for controlling vacuuming.  I just
> wouldn't extrapolate your experience too far here.

I wasn't claiming it's a the best approach for vacuuming.

view thread (11+ messages)

Message-ID: <464F7C54.7090902@cheapcomplexdevices.com>
Permalink:  ../464F7C54.7090902@cheapcomplexdevices.com/
Also on:    postgresql.org/message-id/464F7C54.7090902@cheapcomplexdevices.com

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: rm_pg@cheapcomplexdevices.com, gsmith@gregsmith.com
  Subject: Re: Background vacuum
  In-Reply-To: <464F7C54.7090902@cheapcomplexdevices.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox