Re: autovacuum not freeing up unused space on 8.3.0

Поиск
Список
Период
Сортировка
От Gregory Stark
Тема Re: autovacuum not freeing up unused space on 8.3.0
Дата
Msg-id 87skzf2a9w.fsf@oxford.xeocode.com
обсуждение исходный текст
Ответ на Re: autovacuum not freeing up unused space on 8.3.0  (Stuart Brooks <stuartb@cat.co.za>)
Ответы Re: autovacuum not freeing up unused space on 8.3.0
Список pgsql-general
"Stuart Brooks" <stuartb@cat.co.za> writes:

> It'll take a few minutes but I'll try and get the information to you. A summary
> is:
>
> Process 1:
> - writing 50 rows/second, 1 row/transaction.
> - every so often delete 100 rows
>
> Process 2:
> - running ANALYZE VERBOSE and pg_total_relation_size every second

You'll probably have to vacuum pg_statistics as well then.

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com
  Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training!

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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: Query meltdown: caching results
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: autovacuum not freeing up unused space on 8.3.0