Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 2B8452E2DCC for ; Fri, 16 Nov 2007 05:40:58 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 22619-05 for ; Fri, 16 Nov 2007 05:40:45 -0400 (AST) Received: from mail.uptime.at (mail.uptime.at [62.116.87.11]) by postgresql.org (Postfix) with ESMTP id 5F0912E2DCF for ; Fri, 16 Nov 2007 05:40:38 -0400 (AST) Received: from [192.168.1.120] (exterminator.ba.uptime.at [195.46.69.54]) by mail.uptime.at (8.13.5/8.13.5) with ESMTP id lAG9eQUZ019003 for ; Fri, 16 Nov 2007 10:40:27 +0100 Message-ID: <473D659B.1070008@nekomancer.net> Date: Fri, 16 Nov 2007 10:40:43 +0100 From: =?ISO-8859-1?Q?G=E1bor_Farkas?= User-Agent: Thunderbird 2.0.0.6 (X11/20071022) MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: autovacuum: recommended? Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV 0.90.2/4810/Fri Nov 16 09:38:11 2007 on mail.uptime.at X-Virus-Status: Clean X-uptime-MailScanner-Information: Please contact uptime Systemloesungen for more Information X-uptime-MailScanner: Clean as a baby X-uptime-MailScanner-SpamCheck: spam, SpamAssassin (not cached, score=6.422, required 5.2, BAYES_99 4.50, BODY_GAPPY_TEXT 1.92) X-uptime-MailScanner-SpamScore: 6.42 X-MailScanner-From: gabor@nekomancer.net X-spam: yes X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/236 X-Sequence-Number: 27651 hi, we are moving one database from postgresql-7.4 to postgresql-8.2.4. we have some cronjobs set up that vacuum the database (some tables more often, some tables less often). now, in pg82, there is the possibility of using the autovacuum. my question is: is it recommended to use it? or in other words, should i only use autovacuum? or it's better to use manual-vacuuming? which one is the "way of the future" :) ? or should i use both auto-vacuum and manual-vacuum? in other words, i'd like to find out, if we should simply stay with the vacuuming-cronjobs, or should we move to using auto-vacuum? and if we should move, should we try to set it up the way that no manual-vacuuming is used anymore? thanks, gabor