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

Jim Nasby-5 wrote
> On 3/5/15 2:06 PM, wambacher wrote:
> Crashed? Or hit by the OOM killer? What's the log say?

killed by OOM, but has only 1.2 GB mem, which is ok to me.

> While this is going on you might as well disable autovac for that table.
> It'll keep crashing and will interfere with your manual vacuums.

did it this morning, the crash was running "vacuum verbose planet_osm_ways"
by cli.

> It sounds at this point like the problem is in vacuuming, not analyze.
> Can you confirm? If so, please forgo analyzing the table until we can
> get vacuum figured out.

yes, it's the vacuum task.

> What's the largest memory size that a vacuum/autovac against that table
> gets to compared to other backends? You meantioned 80-90% of memory
> before, but I don't know if that was for analyze or what.

vacuum

> I wonder if we have some kind of memory leak in GIN's vacuum support...

may be.

At least i did:

- droped the gin-index
- cluster
- analyze
- vacuum

all without any problems.

now i'll add the index again and tomorrow do another vacuum by hand.

2:30 in germany, feeling tired ;)

Regards
walter

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