Re: 500 requests per second

Поиск
Список
Период
Сортировка
От Jim C. Nasby
Тема Re: 500 requests per second
Дата
Msg-id 20070521204655.GL62346@nasby.net
обсуждение исходный текст
Ответ на Re: 500 requests per second  ("Merlin Moncure" <mmoncure@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: PFC
Дата:
Сообщение: Re: 500 requests per second
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Postgres Benchmark Results