Re: Performance query about large tables, lots of concurrent access

Поиск
Список
Период
Сортировка
От Francisco Reyes
Тема Re: Performance query about large tables, lots of concurrent access
Дата
Msg-id cone.1182267644.183472.90929.5001@35st.simplicato.com
обсуждение исходный текст
Ответ на Performance query about large tables, lots of concurrent access  (Karl Wright <kwright@metacarta.com>)
Список pgsql-performance
Дерево обсуждения 
Gregory Stark writes:

> VACUUM doesn't require shutting down the system, it doesn't lock any tables or
> otherwise prevent other jobs from making progress. It does add extra i/o but

In addition to what Gregory pointed out, you may want to also consider using
Autovacuum. That may also help.

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

Предыдущее
От: Francisco Reyes
Дата:
Сообщение: Re: Hardware suggestions
Следующее
От: Francisco Reyes
Дата:
Сообщение: Re: Performance query about large tables, lots of concurrent access