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

help / color / mirror / Atom feed
From: Alvaro Herrera <alvherre@commandprompt.com>
To: Mark Wong <markwkm@gmail.com>
Cc: Gregory Stark <stark@enterprisedb.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Cc: Selena Deckelmann <selenamarie@gmail.com>
Cc: Gabrielle Roth <gorthx@gmail.com>
Subject: Re: dbt-2 tuning results with postgresql-8.3.5
Date: Tue, 23 Dec 2008 09:01:06 -0300
Message-ID: <20081223120106.GC6217@alvh.no-ip.org> (raw)
In-Reply-To: <70c01d1d0812221936o57e54ec1j20b15309141672d5@mail.gmail.com>
References: <70c01d1d0812201654i5f55150ep619a6c7ff094470@mail.gmail.com>
	<87hc4yuxbl.fsf@oxford.xeocode.com>
	<552F108E-9732-4ED6-B45D-6C651C63565E@gmail.com>
	<87d4fkvgtj.fsf@oxford.xeocode.com>
	<70c01d1d0812220050kb1f755etea3ecada3f3b8631@mail.gmail.com>
	<871vw0v5ot.fsf@oxford.xeocode.com>
	<70c01d1d0812221936o57e54ec1j20b15309141672d5@mail.gmail.com>

Mark Wong escribió:

> Hrm, tracking just the launcher process certainly doesn't help.  Are
> the spawned processed short lived?  I take a snapshot of
> /proc/<pid>/io data every 60 seconds.

The worker processes can be short-lived, but if they are, obviously they
are not vacuuming the large tables.  If you want to track all autovacuum
actions, change autovacuum_log_min_messages to 0.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support



view thread (15+ messages)  latest in thread

Message-ID: <20081223120106.GC6217@alvh.no-ip.org>
Permalink:  ../20081223120106.GC6217@alvh.no-ip.org/
Also on:    postgresql.org/message-id/20081223120106.GC6217@alvh.no-ip.org

 · 

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: alvherre@commandprompt.com, markwkm@gmail.com, stark@enterprisedb.com, selenamarie@gmail.com, gorthx@gmail.com
  Subject: Re: dbt-2 tuning results with postgresql-8.3.5
  In-Reply-To: <20081223120106.GC6217@alvh.no-ip.org>

* 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