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

Поиск
Список
Период
Сортировка
От wnordmann@gmx.de
Тема BUG #12850: ANALYZE of big table is taking extreemly much memory
Дата
Msg-id 20150311163510.4035.18336@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #12850: ANALYZE of big table is taking extreemly much memory  (Heikki Linnakangas <hlinnaka@iki.fi>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      12850
Logged by:          walter nordmann
Email address:      wnordmann@gmx.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

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Devrim Gündüz
Дата:
Сообщение: Re: compatibilty postgres 9.2 RHEL 6.4
Следующее
От: chhui@ps.asl.com.hk
Дата:
Сообщение: BUG #12851: Failed to initial Jackrabbit JCR Repository