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@xxxxxxxxxxxxxxxx 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
