Re: BUG #5196: Excessive memory consumption when using csvlog - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #5196: Excessive memory consumption when using csvlog
Date
Msg-id 2352.1258596708@sss.pgh.pa.us
Whole thread Raw
In response to BUG #5196: Excessive memory consumption when using csvlog  ("Poindessous Thomas" <thomas@poindessous.com>)
Responses Re: BUG #5196: Excessive memory consumption when using csvlog  (Thomas Poindessous <thomas@poindessous.com>)
List pgsql-bugs
"Poindessous Thomas" <thomas@poindessous.com> writes:
> we have a weird bug. When using csvlog instead of stderr, the postgres
> logger process uses a lot of memory. We even had an OOM error with kernel.

I poked at this a bit and noted that if only one of the two possible
output files is rotated, logfile_rotate() leaks a copy of the other
file's name.  At the default settings this would only amount to one
filename string for every 10MB of output ... how much log output
does your test scenario generate?

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Poindessous Thomas"
Date:
Subject: BUG #5196: Excessive memory consumption when using csvlog
Next
From: Robert Haas
Date:
Subject: Re: BUG #5175: Unable to configure psqlodbc-08.04.0100