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