pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
effects of cancelling a vacuum full
3+ messages / 3 participants
[nested] [flat]

* effects of cancelling a vacuum full
@ 2006-01-18 18:17  Anjan Dave <adave@vantage.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Anjan Dave @ 2006-01-18 18:17 UTC (permalink / raw)
  To: pgsql-admin

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?
 
Thanks,
Anjan
 
 
This email message and any included attachments constitute confidential
and privileged information intended exclusively for the listed
addressee(s). If you are not the intended recipient, please notify
Vantage by immediately telephoning 215-579-8390, extension 1158.  In
addition, please reply to this message confirming your receipt of the
same in error.  A copy of your email reply can also be sent to
mailto:support@vantage.com <blocked::mailto:support@vantage.com> .
Please do not disclose, copy, distribute or take any action in reliance
on the contents of this information.  Kindly destroy all copies of this
message and any attachments.  Any other use of this email is prohibited.
Thank you for your cooperation.  For more information about Vantage,
please visit our website at http://www.vantage.com.

 

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: effects of cancelling a vacuum full
@ 2006-01-18 18:23  Scott Marlowe <smarlowe@g2switchworks.com>
  parent: Anjan Dave <adave@vantage.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Scott Marlowe @ 2006-01-18 18:23 UTC (permalink / raw)
  To: Anjan Dave <adave@vantage.com>; +Cc: pgsql-admin

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.



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: effects of cancelling a vacuum full
@ 2006-01-19 10:40  Gourish Singbal <gourish@gmail.com>
  parent: Scott Marlowe <smarlowe@g2switchworks.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Gourish Singbal @ 2006-01-19 10:40 UTC (permalink / raw)
  To: Anjan Dave <adave@vantage.com>; +Cc: Scott Marlowe <smarlowe@g2switchworks.com>; pgsql-admin

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

^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2006-01-19 10:40 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-01-18 18:17 effects of cancelling a vacuum full Anjan Dave <adave@vantage.com>
2006-01-18 18:23 ` Scott Marlowe <smarlowe@g2switchworks.com>
2006-01-19 10:40   ` Gourish Singbal <gourish@gmail.com>

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