Re: PostgreSQL (9.3 and 9.6) eats all memory when using many tables

Поиск
Список
Период
Сортировка
Искать
От
Jeff Janes
Тема
Re: PostgreSQL (9.3 and 9.6) eats all memory when using many tables
Дата
Msg-id
CAMkU=1xLbimBPzP1xobkO-sUw2iELD3Emvn7zw0SwCYnkoSeSw@mail.gmail.com
Ответ на
Re: PostgreSQL (9.3 and 9.6) eats all memory when using many tables (Tom Lane)
Список
Дерево обсуждения
PostgreSQL (9.3 and 9.6) eats all memory when using many tables hubert depesz lubaczewski <depesz@depesz.com>
Re: PostgreSQL (9.3 and 9.6) eats all memory when using many tables Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: PostgreSQL (9.3 and 9.6) eats all memory when using many tables hubert depesz lubaczewski <depesz@depesz.com>
Re: PostgreSQL (9.3 and 9.6) eats all memory when using many tables hubert depesz lubaczewski <depesz@depesz.com>
Re: PostgreSQL (9.3 and 9.6) eats all memory when using many tables Jeff Janes <jeff.janes@gmail.com>
Re: PostgreSQL (9.3 and 9.6) eats all memory when using many tables hubert depesz lubaczewski <depesz@depesz.com>
Re: PostgreSQL (9.3 and 9.6) eats all memory when using many tables Tom Lane <tgl@sss.pgh.pa.us>
Re: PostgreSQL (9.3 and 9.6) eats all memory when using many tables hubert depesz lubaczewski <depesz@depesz.com>
Re: PostgreSQL (9.3 and 9.6) eats all memory when using many tables Jeff Janes <jeff.janes@gmail.com>
Re: PostgreSQL (9.3 and 9.6) eats all memory when using many tables Jeff Janes <jeff.janes@gmail.com>
Re: PostgreSQL (9.3 and 9.6) eats all memory when using many tables Tom Lane <tgl@sss.pgh.pa.us>
Re: PostgreSQL (9.3 and 9.6) eats all memory when using many tables Jeff Janes <jeff.janes@gmail.com>
Re: PostgreSQL (9.3 and 9.6) eats all memory when using many tables hubert depesz lubaczewski <depesz@depesz.com> 
On Mon, Jun 13, 2016 at 6:36 AM, Tom Lane  wrote:

> Another problem, if the bloat is being driven by explicit PREPARE commands
> as you illustrate here, is that the backend doesn't get to silently
> discard prepared statements.

In the perl script he showed, the handle returned by $dbh->prepare is
not stored anywhere, so it should automatically get garbage collected
at the end of the Perl statement.  The garbage collection should
trigger a destructor to send a "DEALLOCATE".

Cheers,

Jeff
В списке pgsql-bugs по дате отправления
Предыдущее
От: hubert depesz lubaczewski
Дата:
Следующее
От: zzia88@gmail.com
Дата:
FAQ