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-03 23:38:54
Message-ID: 1425425934711-5840305.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Lane-2 wrote
> Maybe you could reduce the statistics targets for that table.

don't understand what you mean. do you mean how often that table is
autovacuumed? at the moment about once a day or once in two days, i think.

> I think we've heard that the analyze functions for PostGIS data types are
> memory hogs, too --- maybe it's worth inquiring about that on the postgis
> mailing listl

good idea and yes, it's a table with postgis-geometries and the
corresponding indices.

will ask the postgis guys too.

at the moment i disabled autovacuum but i'll need it soon again, because the
server is running 24/7 and data is changing permantly.

thanks
walter

btw: no big problems in my mini-config, ok?

--
View this message in context: http://postgresql.nabble.com/autovacuum-worker-running-amok-and-me-too-tp5840299p5840305.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 Tom Lane 2015-03-03 23:48:42 Re: autovacuum worker running amok - and me too ;)
Previous Message Tom Lane 2015-03-03 23:17:01 Re: autovacuum worker running amok - and me too ;)