| From: | "John R Pierce" <pierce(at)hogranch(dot)com> |
|---|---|
| To: | "Vadim Passynkov" <Vadim(dot)Passynkov(at)pathcom(dot)com>, <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Re: BUG #1258: backend memory leak after massive 'CREATE/DROP USER' |
| Date: | 2004-09-18 00:42:52 |
| Message-ID: | 0e1e01c49d18$6e069e80$0200a8c0@hogranch.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 ?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-09-18 01:24:53 | Re: BUG #1258: backend memory leak after massive 'CREATE/DROP USER' |
| Previous Message | PostgreSQL Bugs List | 2004-09-17 23:54:24 | BUG #1258: backend memory leak after massive 'CREATE/DROP USER' |