From: Gourish Singbal <gourish@gmail.com>
To: Anjan Dave <adave@vantage.com>
Cc: Scott Marlowe <smarlowe@g2switchworks.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: effects of cancelling a vacuum full
Date: Thu, 19 Jan 2006 16:10:54 +0530
Message-ID: <674d1f8a0601190240x17d44701td800f765aaab70de@mail.gmail.com> (raw)
In-Reply-To: <1137608625.25500.83.camel@state.g2switchworks.com>
References: <4BAFBB6B9CC46F41B2AD7D9F4BBAF78504015D89@vt-pe2550-001.vantage.vantage.com>
<1137608625.25500.83.camel@state.g2switchworks.com>
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 <smarlowe@g2switchworks.com> 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 table
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: gourish@gmail.com, adave@vantage.com, smarlowe@g2switchworks.com
Subject: Re: effects of cancelling a vacuum full
In-Reply-To: <674d1f8a0601190240x17d44701td800f765aaab70de@mail.gmail.com>
References: <4BAFBB6B9CC46F41B2AD7D9F4BBAF78504015D89@vt-pe2550-001.vantage.vantage.com> <1137608625.25500.83.camel@state.g2switchworks.com> <674d1f8a0601190240x17d44701td800f765aaab70de@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox