Search Postgresql Archives

simulating high load for vacuum full

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux