Re: [ADMIN] Assimilation of these "versus" and hardware threads

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Cc: "Matthew T(dot) O'Connor" <matthew(at)tocr(dot)com>
Subject: Re: [ADMIN] Assimilation of these "versus" and hardware threads
Date: 2005-01-11 20:52:29
Message-ID: 200501111252.29942.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-performance

Matt,

> I had one comment on the pg_autovacuum section. Near the bottom it
> lists some of it's limitations, and I want to clarify the 1st one: "Does
> not reset the transaction counter". I assume this is talking about the
> xid wraparound problem? If so, then that bullet can be removed.
> pg_autovacuum does check for xid wraparound and perform a database wide
> vacuum analyze when it's needed.

Keen. That's an 8.0 fix?

--
Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Lee Wu 2005-01-11 21:11:43 Re: Vacuum full - disk space eaten by WAL logfiles
Previous Message BASEI, Sidnei R. 2005-01-11 20:48:09 PostgreSQL Performance

Browse pgsql-performance by date

  From Date Subject
Next Message Matthew T. O'Connor 2005-01-11 21:44:55 Re: [ADMIN] Assimilation of these "versus" and hardware
Previous Message Pete de Zwart 2005-01-11 20:25:43 Re: Best filesystem for PostgreSQL Database Cluster under Linux