X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id A7AACD1D201 for ; Thu, 29 Jan 2004 16:33:10 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 01438-07 for ; Thu, 29 Jan 2004 12:32:38 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 33640D1B45C for ; Thu, 29 Jan 2004 12:32:34 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i0TGWTsP023607; Thu, 29 Jan 2004 11:32:30 -0500 (EST) To: "Iain" Cc: pgsql-admin@postgresql.org Subject: Re: Routine maintenance - vacuum, analyse and autovacuum In-reply-to: <000901c3e64e$9611c390$7201a8c0@mst1x5r347kymb> References: <000901c3e64e$9611c390$7201a8c0@mst1x5r347kymb> Comments: In-reply-to "Iain" message dated "Thu, 29 Jan 2004 18:59:28 +0900" Date: Thu, 29 Jan 2004 11:32:29 -0500 Message-ID: <23606.1075393949@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/270 X-Sequence-Number: 12133 "Iain" writes: > If we use it, can we stop using nightly vacuums? I'd like to do this if > possible, since the current version (it's a 7.1 db) of the system runs a > number of batch processes at night (large deletes and large inserts), and > finishes with a vacuum analyse. The vacuum takes quite a long time and the > nightly window is gradually getting tighter and tighter. Just moving from 7.1 to 7.4 should help, since you can start using plain vacuum (7.1's vacuum is equivalent to vacuum full IIRC). > If I start a VACUUM FULL, is it ok to interrupt it part way through? I mean, > is a partially completed vacuum full worth anything, and is there any danger > in routinely killing it? It's crash-safe but you may leave your indexes bigger than before :-( regards, tom lane