Re: BUG #1258: backend memory leak after massive 'CREATE/DROP USER'

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: BUG #1258: backend memory leak after massive 'CREATE/DROP USER'
Дата
Msg-id 0e1e01c49d18$6e069e80$0200a8c0@hogranch.com
обсуждение исходный текст
Ответ на BUG #1258: backend memory leak after massive 'CREATE/DROP USER'  ("PostgreSQL Bugs List" <pgsql-bugs@postgresql.org>)
Список pgsql-bugs
> Description:        backend memory leak after massive 'CREATE/DROP USER'

wild guess says that its not really neccessarily a memory leak unless all
the shared_buffers are getting consumed and its *still* growing...

CREATE USER adds a row to a system table, and DROP USER deletes that row,
the table space will grow on disk until you do a VACUUM to release the free
rows.   Doing this without any VACUUM's will likely continue to allocate
shared_buffers until they are used up (thats what they are for, after all).

have you run this process for hours and hours and many millions of users,
such that the memory finally grows so big it crashes or errors out ?

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

Предыдущее
От: "PostgreSQL Bugs List"
Дата:
Сообщение: BUG #1258: backend memory leak after massive 'CREATE/DROP USER'
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #1258: backend memory leak after massive 'CREATE/DROP USER'