BUG #12850: ANALYZE of big table is taking extreemly much memory

From: wnordmann(at)gmx(dot)de
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #12850: ANALYZE of big table is taking extreemly much memory
Date: 2015-03-11 16:35:10
Message-ID: 20150311163510.4035.18336@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 12850
Logged by: walter nordmann
Email address: wnordmann(at)gmx(dot)de
PostgreSQL version: 9.4.1
Operating system: Ubuntu 14.4 LTS
Description:

Vacuuming a really big table (139.000.000 records, 66GB tablespace, one
GIN-INDEX of 135 GB!) is consuming extreemly much memory. Much, much more
then maintenance_work_mem (2GB). at this time about 85 GB of virt mem.

see post "autovacuum worker running amok - and me too" at postgresql-general
or ask me for more data. this form is to small for it.

regards
walter

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message chhui 2015-03-11 16:55:56 BUG #12851: Failed to initial Jackrabbit JCR Repository
Previous Message Devrim Gündüz 2015-03-11 16:35:06 Re: compatibilty postgres 9.2 RHEL 6.4