From: Craig Ringer <craig@postnewspapers.com.au>
To: pgsql-performance@postgresql.org
Subject: Re: Memory usage of auto-vacuum
Date: Sat, 09 Jul 2011 16:31:47 +0800
Message-ID: <4E1811F3.80705@postnewspapers.com.au> (raw)
In-Reply-To: <plop87tyavncer.fsf@aoskar.kilobug.org>
References: <plop87tyavncer.fsf@aoskar.kilobug.org>
On 9/07/2011 3:25 PM, Gael Le Mignot wrote:
>
> Hello,
>
> We are running a PostgreSQL 8.4 database, with two tables containing a
> lot (> 1 million) moderatly small rows. It contains some btree indexes,
> and one of the two tables contains a gin full-text index.
>
> We noticed that the autovacuum process tend to use a lot of memory,
> bumping the postgres process near 1Gb while it's running.
What is maintenance_work_mem set to in postgresql.conf?
--
Craig Ringer
POST Newspapers
276 Onslow Rd, Shenton Park
Ph: 08 9381 3088 Fax: 08 9388 2258
ABN: 50 008 917 717
http://www.postnewspapers.com.au/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: craig@postnewspapers.com.au
Subject: Re: Memory usage of auto-vacuum
In-Reply-To: <4E1811F3.80705@postnewspapers.com.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox