Re: 500 requests per second - Mailing list pgsql-performance

From Jim C. Nasby
Subject Re: 500 requests per second
Date
Msg-id 20070521204655.GL62346@nasby.net
Whole thread Raw
In response to Re: 500 requests per second  ("Merlin Moncure" <mmoncure@gmail.com>)
List pgsql-performance
On Mon, May 21, 2007 at 03:50:27PM -0400, Merlin Moncure wrote:
> I work on a system about like you describe....400tps constant....24/7.
> Major challenges are routine maintenance and locking.  Autovacuum is
> your friend but you will need to schedule a full vaccum once in a
> while because of tps wraparound.  If you allow AV to do this, none of
> your other tables get vacuumed until it completes....heh!

BTW, that's changed in either 8.2 or 8.3; the change is that freeze
information is now tracked on a per-table basis instead of per-database.
So autovacuum isn't forced into freezing everything in the database at
once.
--
Jim Nasby                                      decibel@decibel.org
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

pgsql-performance by date:

Previous
From: PFC
Date:
Subject: Re: 500 requests per second
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Postgres Benchmark Results