memory leak in GIN
От
Jaime Casanova
Тема
memory leak in GIN
Дата
Msg-id
CAJGNTeMR1ndMU2Thpr8GPDUfiHTV7idELJRFusA5UXUGY1y-eA@mail.gmail.com
Список
Дерево обсуждения
memory leak in GIN Jaime Casanova <jaime.casanova@2ndquadrant.com>
Re: memory leak in GIN Jeff Janes <jeff.janes@gmail.com>
Re: memory leak in GIN Tom Lane <tgl@sss.pgh.pa.us>
Hi, On the spanish list, Felipe de Jesús Molina Bravo, reported a few days back that a query that worked well in 9.4 consume all memory in 9.5. With the self contained test he provided us i reproduced the problem in 9.5 and 9.6dev. To test, execute: pba.sql -- to create the tables and populate query_crash.sql -- this will consume all your memory and crash your server eventually If you drop the GIN indexes, the problem disappear. I used valgrind to try to hunt the memory leak, attached the resulting log showing the backend that executed the query. And from the little a could say from the stack trace valgrind showed, the problem is around ginPostingListDecodeAllSegments() but i don't see any modifications there. -- Jaime Casanova www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
В списке pgsql-hackers по дате отправления
От: Tom Lane
Дата: