pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
How far does interrupting vacuum full rollback?
3+ messages / 2 participants
[nested] [flat]

* How far does interrupting vacuum full rollback?
@ 2007-05-15 23:37  Nick Urbanik <nicku@nicku.org>
  0 siblings, 1 reply; 3+ messages in thread

From: Nick Urbanik @ 2007-05-15 23:37 UTC (permalink / raw)
  To: pgsql-admin

Dear Folks,

I would like to interrupt this full vacuum run as:

vacuum full verbose;

which has vacuumed a number of tables.

Will interrupting it (with Control-C) cause vacuuming of the previous
tables to be rolled back, or just the vacuuming of the current table?

WIll any of the work done on the current table remain if the vacuuming
process is interrupted?

This is PostgreSQL 7.3.8.
-- 
Nick Urbanik   RHCE         http://nicku.org        nicku@nicku.org
GPG: 7FFA CDC7 5A77 0558 DC7A 790A 16DF EC5B BB9D 2C24 ID: BB9D2C24

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

* Re: How far does interrupting vacuum full rollback?
@ 2007-05-16 00:59  Jim C. Nasby <decibel@decibel.org>
  parent: Nick Urbanik <nicku@nicku.org>
  0 siblings, 1 reply; 3+ messages in thread

From: Jim C. Nasby @ 2007-05-16 00:59 UTC (permalink / raw)
  To: pgsql-admin

On Wed, May 16, 2007 at 09:37:28AM +1000, Nick Urbanik wrote:
> Dear Folks,
> 
> I would like to interrupt this full vacuum run as:
> 
> vacuum full verbose;
> 
> which has vacuumed a number of tables.
> 
> Will interrupting it (with Control-C) cause vacuuming of the previous
> tables to be rolled back, or just the vacuuming of the current table?
 
Just the current table.

> WIll any of the work done on the current table remain if the vacuuming
> process is interrupted?
 
If it's had to cycle though the heap more than once due to running out
of maintenance_work_mem (or whatever it's called in 7.3) then I believe
some of the work will be saved.

> This is PostgreSQL 7.3.8.

You should strongly consider upgrading to 8.2 or at least 8.1. If
nothing else at least get on the latest 7.3 version.
-- 
Jim Nasby                                      decibel@decibel.org
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)



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

* Re: How far does interrupting vacuum full rollback?
@ 2007-05-16 01:18  Nick Urbanik <nicku@nicku.org>
  parent: Jim C. Nasby <decibel@decibel.org>
  0 siblings, 0 replies; 3+ messages in thread

From: Nick Urbanik @ 2007-05-16 01:18 UTC (permalink / raw)
  To: pgsql-admin

Dear Folks,

I would like to extend a big "Thank You" to all the great people who
answered my questions so quickly and helpfully.  I'd love to buy you
all a beer!

On 15/05/07 19:59 -0500, Jim C. Nasby wrote:
>On Wed, May 16, 2007 at 09:37:28AM +1000, Nick Urbanik wrote:
>> Will interrupting it (with Control-C) cause vacuuming of the previous
>> tables to be rolled back, or just the vacuuming of the current table?
> 
>Just the current table.

Thank you!  You were absolutely right there.

>> WIll any of the work done on the current table remain if the vacuuming
>> process is interrupted?
> 
>If it's had to cycle though the heap more than once due to running out
>of maintenance_work_mem (or whatever it's called in 7.3) then I believe
>some of the work will be saved.

Thanks.  It actually completed on that table before I interrupted it.
Everything is back in action, and I now breath more freely.

>> This is PostgreSQL 7.3.8.
>
>You should strongly consider upgrading to 8.2 or at least 8.1. If
>nothing else at least get on the latest 7.3 version.

Yes, I understand, but this system has been in production for some
time, and along with many others, will get an upgrade, but only when
we have time.  It's hard for a team of six people to manage around 430
servers as well as work on many other projects.  We just do the best
we can.
-- 
Nick Urbanik   RHCE         http://nicku.org        nicku@nicku.org
GPG: 7FFA CDC7 5A77 0558 DC7A 790A 16DF EC5B BB9D 2C24 ID: BB9D2C24

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


end of thread, other threads:[~2007-05-16 01:18 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-05-15 23:37 How far does interrupting vacuum full rollback? Nick Urbanik <nicku@nicku.org>
2007-05-16 00:59 ` Jim C. Nasby <decibel@decibel.org>
2007-05-16 01:18   ` Nick Urbanik <nicku@nicku.org>

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