X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 6A7E89DC80D for ; Thu, 19 Jan 2006 06:40:55 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 85654-07 for ; Thu, 19 Jan 2006 06:40:56 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.201]) by postgresql.org (Postfix) with ESMTP id 669929DC841 for ; Thu, 19 Jan 2006 06:40:52 -0400 (AST) Received: by zproxy.gmail.com with SMTP id 13so174953nzn for ; Thu, 19 Jan 2006 02:40:54 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=Zp2scwUXvYG83mAjn4n+l4+eAPqGO7/BQnva1NrCzBgFffShn6JWUeYayMN2+ERAEiHyHtaf+AwZRkK6PUtPjF3I0AAs+CanuF3e/4pjU+HqO2TkBwaFO5BJ2F6QOnnHVzfIp5ozefIyog1iZ47HHj7WEYgjD9nqlKC7MAlhmg0= Received: by 10.36.227.68 with SMTP id z68mr397547nzg; Thu, 19 Jan 2006 02:40:54 -0800 (PST) Received: by 10.36.68.1 with HTTP; Thu, 19 Jan 2006 02:40:54 -0800 (PST) Message-ID: <674d1f8a0601190240x17d44701td800f765aaab70de@mail.gmail.com> Date: Thu, 19 Jan 2006 16:10:54 +0530 From: Gourish Singbal To: Anjan Dave Subject: Re: effects of cancelling a vacuum full Cc: Scott Marlowe , pgsql-admin@postgresql.org In-Reply-To: <1137608625.25500.83.camel@state.g2switchworks.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_8520_3095178.1137667254735" References: <4BAFBB6B9CC46F41B2AD7D9F4BBAF78504015D89@vt-pe2550-001.vantage.vantage.com> <1137608625.25500.83.camel@state.g2switchworks.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.136 required=5 tests=[AWL=0.135, HTML_MESSAGE=0.001] X-Spam-Score: 0.136 X-Spam-Level: X-Archive-Number: 200601/216 X-Sequence-Number: 20304 ------=_Part_8520_3095178.1137667254735 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline One Question out of curiosity .. How did u cancel the vacuum full ?. 1. killed the process id .. eg using kill -9 2. canceled the vacuum full from command prompt eg using "ctrl C". 3. or did an immediate shutdown . On 1/18/06, Scott Marlowe wrote: > > On Wed, 2006-01-18 at 12:17, Anjan Dave wrote: > > Hi, > > > > I just had to cancel one VACUUM FULL (of a 4.3m row table) that someone > ran in business hours. It was after an hour or so that I realized, and it > was blocking queries, running out of connections, so I cancelled it. Are > there any bad side effects of cancelling an ongoing full vacuum of a tabl= e > or a database? Does a partial full vacuum give back any space? > > > > No damage done. > No space returned. > Just wait and run it again later. > Tell your used to do a vacuum regular during business hours or you'll > have to give him a stern talking to. > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > -- Best, Gourish Singbal ------=_Part_8520_3095178.1137667254735 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
 
One Question out of curiosity .. How did u cancel the vacuum full ?.
1. killed the process id  .. eg using kill -9
2. canceled the vacuum full from command prompt eg using "ctrl C&= quot;.
3. or did an immediate shutdown .


 
On 1/18/06, = Scott Marlowe <smarlow= e@g2switchworks.com> wrote:
On Wed, 2006-01-18 at 12:17, Anj= an Dave wrote:
> Hi,
>
> I just had to cancel one VACUUM = FULL (of a=20 4.3m row table) that someone ran in business hours. It was after an hour or= so that I realized, and it was blocking queries, running out of connection= s, so I cancelled it. Are there any bad side effects of cancelling an ongoi= ng full vacuum of a table or a database? Does a partial full vacuum give ba= ck any space?
>

No damage done.
No space returned.
Just wait and run = it again later.
Tell your used to do a vacuum regular during business ho= urs or you'll
have to give him a stern talking to.

--------------= -------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to      choose an index scan if your joining c= olumn's datatypes do not
      match



--
Best,
Gourish Singbal=20 ------=_Part_8520_3095178.1137667254735--