Re: Postgres 9.1.4 - high stats collector IO usage

Поиск
Список
Период
Сортировка
От David Barton
Тема Re: Postgres 9.1.4 - high stats collector IO usage
Дата
Msg-id 50141D5A.2090302@oneit.com.au
обсуждение исходный текст
Ответ на Re: Postgres 9.1.4 - high stats collector IO usage  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-performance
Thanks, Pavel.

I was a bit worried about trying this because of a comment elsewhere that the file was supposed to be permanent.  Tom's solution of increasing the vacuum delay has solved it for now.

Regards, David


On 28/07/12 15:07, Pavel Stehule wrote:
Hello

I had same problem with large numbers of tables - you can move
pg_stat_tmp to tmpfs filesystem - it was solution for us

Regards

Pavel

2012/7/28 David Barton <dave@oneit.com.au>:
Hi,

<snip>

--

David Barton - Managing Director
1iT Pty Ltd "The Power of One"

Tel: (08) 9382 2296
Direct: (08) 9200 4269
Mob: 0404 863 671
Fax: (08) 6210 1354
Web: www.1it.com.au

First Floor
41 Oxford Close
West Leederville, 6007

Вложения

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

Предыдущее
От: David Barton
Дата:
Сообщение: Re: Postgres 9.1.4 - high stats collector IO usage
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Linux memory zone reclaim