Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 5A4A8B5DBFE for ; Sun, 10 Jul 2011 12:49:58 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 24672-01 for ; Sun, 10 Jul 2011 15:49:52 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from aoskar.kilobug.org (kilobug.org [62.212.118.231]) by mail.postgresql.org (Postfix) with ESMTP id C524BB5D803 for ; Sun, 10 Jul 2011 12:49:51 -0300 (ADT) Received: from kilobug by aoskar.kilobug.org with local (Exim 4.72) (envelope-from ) id 1QfquN-000221-V6; Sun, 10 Jul 2011 12:06:40 +0200 From: Gael Le Mignot To: Tom Lane Cc: Gael Le Mignot , Guillaume Lelarge , pgsql-performance@postgresql.org Subject: Re: Memory usage of auto-vacuum Organization: Pilot Systems References: <1310200383.2101.8.camel@laptop> <1310201594.2101.12.camel@laptop> <1310202377.2101.15.camel@laptop> <6538.1310228598@sss.pgh.pa.us> Mail-Copies-To: nobody X-Revolutionnary-Date: 22 Messidor an 219 de la =?iso-8859-1?Q?R=E9volutio?= =?iso-8859-1?Q?n?= X-PGP-Fingerprint: 1F2C 9804 7505 79DF 95E6 7323 B66B F67B 7103 C5DA Date: Sun, 10 Jul 2011 12:06:38 +0200 In-Reply-To: <6538.1310228598@sss.pgh.pa.us> (Tom Lane's message of "Sat, 09 Jul 2011 12:23:18 -0400") Message-ID: User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.2 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201107/78 X-Sequence-Number: 44290 Hello Tom! Sat, 09 Jul 2011 12:23:18 -0400, you wrote: > Gael Le Mignot writes: >> Sat, 09 Jul 2011 11:06:16 +0200, you wrote: >>>> BTW, what's your PostgreSQL release? I assume at least 8.3 since you're >>>> using FTS? >> It's 8.4 from Debian Squeeze. > 8.4.what? It's 8.4.8-0squeeze1 > In particular I'm wondering if you need this 8.4.6 fix: > http://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=f0e4331d04fa007830666c5baa2c3e37cce9c3ff Thanks for the tip, it very well could have been that, but it's 8.4.8, I checked the concerned source file and the patch is there, and I didn't find any Debian-specific patch that could collide with it. Regards, -- Gaël Le Mignot - gael@pilotsystems.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