Re: autovacuum worker running amok - and me too ;)

Поиск
Список
Период
Сортировка
От wambacher
Тема Re: autovacuum worker running amok - and me too ;)
Дата
Msg-id 1425582703890-5840685.post@n5.nabble.com
обсуждение исходный текст
Ответ на Re: autovacuum worker running amok - and me too ;)  (Kevin Grittner <kgrittn@ymail.com>)
Ответы Re: autovacuum worker running amok - and me too ;)  (wambacher <wnordmann@gmx.de>)
Список pgsql-general
Hi,

in my first post you can see all params:

maintenance_work_mem = 64MB and two workers. i configured my system to the
absolutely minimum (  got 24 GB real  memory) and the problem was still
there.

Last night i rebuilt one index (122GB Size) and just in this minutes i
started a manual "analyze verbose planet_osm_ways" to see whats happening.
this will need some hours.

Regards
walter



--
View this message in context:
http://postgresql.nabble.com/autovacuum-worker-running-amok-and-me-too-tp5840299p5840685.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Sharing data between stored functions?
Следующее
От: Jim Nasby
Дата:
Сообщение: Re: Sharing data between stored functions?