Re: Memory usage of auto-vacuum

Hello Craig!

Sat, 09 Jul 2011 16:31:47 +0800, you wrote:

> 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?

It's the debian default, which is 16Mb. Do you think we should reduce it ?

I also forgot to add something which may be important : there are a lot
of INSERT (and SELECT) in those tables, but very few UPDATE/DELETE.

Regards,

--
Gaël Le Mignot - gael(at)pilotsystems(dot)net
Pilot Systems - 9, rue Desargues - 75011 Paris
Tel : +33 1 44 53 05 55 - www.pilotsystems.net
Gérez vos contacts et vos newsletters : www.cockpit-mailing.com