| From: | Jochen Erwied <jochen(at)pgsql-bugs(dot)erwied(dot)eu> |
|---|---|
| To: | Andres Freund <andres(at)anarazel(dot)de> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: Postgresql 9.1.2 - abnormal memory usage |
| Date: | 2011-12-12 07:04:44 |
| Message-ID: | 1238340844.20111212080444@erwied.eu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Monday, December 12, 2011, 1:45:42 AM you wrote:
> Jochen, could you try the attached patch?
Patch is missing a variable define for 'r' in network_sup(). Fixed patch
attached.
Memory usage for insert ~1087MB - no change
Memory usage for index creation ~415MB - fixed.
Memory usage for select ~150MB - no increase, also fixed
The patch works for me, I'll leave the discussion if it's correct way to do
it to the developers :-)
--
Jochen Erwied | home: jochen(at)erwied(dot)eu +49-208-38800-18, FAX: -19
Sauerbruchstr. 17 | work: joe(at)mbs-software(dot)de +49-2151-7294-24, FAX: -50
D-45470 Muelheim | mobile: jochen(dot)erwied(at)vodafone(dot)de +49-173-5404164
| Attachment | Content-Type | Size |
|---|---|---|
| 0001-Release-memory-in-inet-functions.patch | application/octet-stream | 3.7 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Heikki Linnakangas | 2011-12-12 08:29:36 | Re: Postgresql 9.1.2 - abnormal memory usage |
| Previous Message | Tom Lane | 2011-12-12 06:26:30 | Re: Postgresql 9.1.2 - abnormal memory usage |