simulating high load for vacuum full

From: Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: simulating high load for vacuum full
Date: 2009-06-17 08:41:18
Message-ID: 20090617104118.3b3829fc@dawn.webthatworks.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm trying to diagnose a problem that happened during vacuum full.

It is a programming problem triggered by some lock, delay whatever,
happening during vacuum.

Making large updates to a bunch of tables is a PITA just to obtain a
slow VACUUM FULL.

Restoring a "fragmented" DB doesn't look as a working strategy.
The restore shouldn't be fragmented.

What are the "side effects" of a vacuum full?
Any cheaper way to cause a heavy vacuum full or just its side
effects?

thanks

--
Ivan Sergio Borgonovo
http://www.webthatworks.it

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Bailey 2009-06-17 08:46:13 Naming functions with reserved words
Previous Message John R Pierce 2009-06-17 08:41:09 Re: PostgreSQL server NOT STARTED