Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 01CED9FBFB5 for ; Tue, 15 May 2007 21:02:06 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 03726-09 for ; Tue, 15 May 2007 21:02:02 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from lists.commandprompt.com (host-254.commandprompt.net [207.173.203.254]) by postgresql.org (Postfix) with ESMTP id A389F9FBBD1 for ; Tue, 15 May 2007 21:02:02 -0300 (ADT) Received: from [192.168.1.2] (or-67-76-146-141.sta.embarqhsd.net [67.76.146.141]) (authenticated bits=0) by lists.commandprompt.com (8.13.7/8.13.6) with ESMTP id l4G020Cx028288; Tue, 15 May 2007 17:02:01 -0700 Message-ID: <464A49F0.1060409@commandprompt.com> Date: Tue, 15 May 2007 17:01:52 -0700 From: "Joshua D. Drake" User-Agent: Thunderbird 2.0.0.0 (Windows/20070326) MIME-Version: 1.0 To: Geoff Tolley CC: pgsql-admin@postgresql.org, nicku@nicku.org Subject: Re: How overcome wait for vacuum full? References: <20070515221356.GG5264@nicku.org> <464A3E24.6060204@polimetrix.com> <20070515232505.GA16021@nicku.org> <464A45C4.6090607@polimetrix.com> In-Reply-To: <464A45C4.6090607@polimetrix.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV version 0.88.5, clamav-milter version 0.88.5 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (lists.commandprompt.com [192.168.2.159]); Tue, 15 May 2007 17:02:01 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/128 X-Sequence-Number: 25448 > Now add primary key, indices, foreign keys, triggers, rules, column > defaults to mytable, and you'll probably want to drop the foreign keys > at least from mytable_old. I'm afraid you'll have to sort out manually > what these should be. > */ > > 7.3.8 is quite seriously old. 7.3.19 is the latest in that tree if you > must stick with it. 7.3 is also considered EOL by the project. Time to upgrade. J > > HTH, > Geoff > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly >