Re: memory leaks fixed?
От | Peter Eisentraut |
---|---|
Тема | Re: memory leaks fixed? |
Дата | |
Msg-id | Pine.LNX.4.30.0104081258230.1236-100000@peter.localdomain обсуждение исходный текст |
Ответ на | memory leaks fixed? ("Nick T" <ntaylor84@earthlink.net>) |
Список | pgsql-general |
Nick T writes: > Just finished reading all of the comments at > > http://openacs.org/philosophy/why-not-mysql.html > > and became concerned about the comments regarding severe memory leaks with > PostgreSQL. Is this true? Have they been fixed? Are there any > workarounds? There are certain queries that require a seemingly unproportional amount of memory. Up until verion 7.0, memory in the server was not recovered until the end of the transaction, so it was possible to run out of memory when it should have been avoidable. This is technically not a memory leak, just a less than optimal use of resources. However, because of the way malloc/sbrk work, this memory is no longer available to the operating system, so it looks like a memory leak. 7.1 uses a better technique to handle the allocated memory, which should fix most of these cases. In any case it should be possible to rewrite the queries, but there is no general procedure on how to do that. -- Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/
В списке pgsql-general по дате отправления: