Re: dbt-2 tuning results with postgresql-8.3.5 - Mailing list pgsql-performance

From Alvaro Herrera
Subject Re: dbt-2 tuning results with postgresql-8.3.5
Date
Msg-id 20081223120106.GC6217@alvh.no-ip.org
Whole thread Raw
In response to Re: dbt-2 tuning results with postgresql-8.3.5  ("Mark Wong" <markwkm@gmail.com>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Greg Smith
Date:
Subject: Re: dbt-2 tuning results with postgresql-8.3.5
Next
From: "Kynn Jones"
Date:
Subject: How to "unique-ify" HUGE table?