Re: Understanding pg_autovacuum CPU Usage

Поиск
Список
Период
Сортировка
От Thomas F.O'Connell
Тема Re: Understanding pg_autovacuum CPU Usage
Дата
Msg-id 183F7600-FC94-11D8-9D1E-000D93AE0944@sitening.com
обсуждение исходный текст
Ответ на Re: Understanding pg_autovacuum CPU Usage  ("Matthew T. O'Connor" <matthew@zeut.net>)
Список pgsql-general
On Sep 1, 2004, at 10:27 PM, Matthew T. O'Connor wrote:

> Number of rows is irrelevant, but the number of tables might not be.
> It could be that the process of checking it's list of tables against
> the server might be slow when used with lots of tables.  Does this cpu
> spike happen every other loop?

Is there an easy way to determine if it's happening every other loop?

> Try the simple recompile with the larger update interval first and see
> if that's the problem.

How difficult would it be to make this a command-line argument if it
turns out to be a run-time issue?

Thanks for the input.

-tfo


В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: The future of built-in geometric data types
Следующее
От: David Fetter
Дата:
Сообщение: Re: The future of built-in geometric data types