Обсуждение: BUG #6716: memory of Autovacuum leak?

Поиск
Список
Период
Сортировка

BUG #6716: memory of Autovacuum leak?

От
runner.mei@gmail.com
Дата:
The following bug has been logged on the website:

Bug reference:      6716
Logged by:          runner.mei
Email address:      runner.mei@gmail.com
PostgreSQL version: 9.1.3
Operating system:   win2003
Description:=20=20=20=20=20=20=20=20

My program using a postgresql9.1.3, and running in win2003. Generally have
17-18 processes of postgresql, the memory of any process no more than 60M,
but today the memory of a process to reach 880M.At first I thought it was
temporary, but until now has been going on for 9 hours, and continues to
grow.The parameters of the process for "- forkavlauncher -x3" someone can
help me?

Re: BUG #6716: memory of Autovacuum leak?

От
Alvaro Herrera
Дата:
Excerpts from runner.mei's message of mi=C3=A9 jul 04 10:03:42 -0400 2012:
> The following bug has been logged on the website:
>=20
> Bug reference:      6716
> Logged by:          runner.mei
> Email address:      runner.mei@gmail.com
> PostgreSQL version: 9.1.3
> Operating system:   win2003
> Description:=20=20=20=20=20=20=20=20
>=20
> My program using a postgresql9.1.3, and running in win2003. Generally have
> 17-18 processes of postgresql, the memory of any process no more than 60M,
> but today the memory of a process to reach 880M.At first I thought it was
> temporary, but until now has been going on for 9 hours, and continues to
> grow.The parameters of the process for "- forkavlauncher -x3" someone can
> help me?

What's your maintenance_work_mem setting?  Also, what does
pg_stat_activity say about that process?

--=20
=C3=81lvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support