0000645: Pgpool memory consumption when increasing the log level

ID	Project	Category	View Status	Date Submitted	Last Update

0000645	Pgpool-II	General	public	2020-08-30 23:05	2020-08-31 13:14

Reporter	van	Assigned To	t-ishii
Priority	normal	Severity	minor	Reproducibility	always
Status	feedback	Resolution	open
Product Version	4.0.2

Summary	0000645: Pgpool memory consumption when increasing the log level
Description	Hi Team, When we increase the pgpool level from error to log , it seems like pgpool processing is getting slow and memory consumption is getting increased . Is this accepted behavior ? and how we overcome with this while keeping the log level to error or debug mode
Tags	No tags attached.

t-ishii 2020-08-31 10:59 developer ~0003535	Which parameter are you talking about? There are two parameters which accept log level. client_min_messages log_min_messages

van 2020-08-31 12:59 reporter ~0003536	Hi t-ishii, log_min_messages When i increase log_min_messages parameter , pgpool is getting slow

t-ishii 2020-08-31 13:12 developer ~0003537	What do you exactly mean "increase log_min_messages parameter"? I am asking because in log_min_messages, "log" is less verbose than "error" (no ERROR message is logged if log_min_messages is set to "log"). Less verbose messages usually result in less memory consumption and faster because less messages are written to log files.

t-ishii 2020-08-31 13:14 developer ~0003538	Also 4.0.2 is pretty old (released almost 2 years ago). You might want to try the latest 4.0 series.

Date Modified	Username	Field	Change
2020-08-30 23:05	van	New Issue
2020-08-31 10:56	t-ishii	Assigned To	=> t-ishii
2020-08-31 10:56	t-ishii	Status	new => assigned
2020-08-31 10:59	t-ishii	Note Added: 0003535
2020-08-31 10:59	t-ishii	Status	assigned => feedback
2020-08-31 12:59	van	Note Added: 0003536
2020-08-31 12:59	van	Status	feedback => assigned
2020-08-31 13:12	t-ishii	Note Added: 0003537
2020-08-31 13:14	t-ishii	Note Added: 0003538
2020-08-31 13:14	t-ishii	Status	assigned => feedback