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

From: wambacher <wnordmann(at)gmx(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: autovacuum worker running amok - and me too ;)
Date: 2015-03-05 19:11:43
Message-ID: 1425582703890-5840685.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jim Nasby 2015-03-05 19:15:55 Re: Sharing data between stored functions?
Previous Message Adrian Klaver 2015-03-05 19:06:58 Re: Sharing data between stored functions?