Postgres Pro
Downloads
Home   >   mailing lists

Re: autovacuum worker running amok - and me too ;) - Mailing list pgsql-general

From wambacher
Subject Re: autovacuum worker running amok - and me too ;)
Date
Msg-id 1425891405255-5841074.post@n5.nabble.com
Whole thread Raw
In response to Re: autovacuum worker running amok - and me too ;)  (Paul Ramsey <pramsey@cleverelephant.ca>)
Responses Re: autovacuum worker running amok - and me too ;)  (wambacher <wnordmann@gmx.de>)
Re: autovacuum worker running amok - and me too ;)  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
List pgsql-general
Tree view 
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?



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

pgsql-general by date:

Previous
From: Chris Mair
Date:
Subject: Re: Performance slowing down when doing same UPDATE many times
Next
From: wambacher
Date:
Subject: Re: autovacuum worker running amok - and me too ;)