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

Поиск
Список
Период
Сортировка
От Jim Nasby
Тема Re: autovacuum worker running amok - and me too ;)
Дата
Msg-id 55246BF7.4040207@BlueTreble.com
обсуждение исходный текст
Ответ на Re: autovacuum worker running amok - and me too ;)  (wambacher <wnordmann@gmx.de>)
Список pgsql-general
On 3/9/15 3:56 AM, wambacher wrote:
> Hi paul
>
> just found my system (24 GB Mem, 72 GB Swap) running nearly at it's limits:
>
> The current vaccum is using 66.7 GB (sixty-six dot seven) GB of memory and
> my System is nearly down.
>
> I'm sorry, but that must be an bug. Remember: It's the Analyze of an
> GIN-Index that is making that problems. Various tables - same Problem.
>
> Regards
> walter
>
> <http://postgresql.nabble.com/file/n5841074/top.png>
> duríng the last 10 Minutes vaccum took one more GB, now it's using 67.5 if
> mem.
>
> should i ask at the dev-list? Open a ticket?

Sorry for the late reply.

Yes, that sounds like a bug in the GIN code. Please post to pgsql-bugs
or hit http://www.postgresql.org/support/submitbug/
--
Jim Nasby, Data Architect, Blue Treble Consulting
Data in Trouble? Get it in Treble! http://BlueTreble.com


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

Предыдущее
От: Jim Nasby
Дата:
Сообщение: Re: Problems with casting
Следующее
От: Jim Nasby
Дата:
Сообщение: Re: Asynchronous replication in postgresql