VACUUM FULL vs CLUSTER

From: Markus Benne <markus(at)m-bass(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: VACUUM FULL vs CLUSTER
Date: 2005-09-20 18:53:19
Message-ID: 1127242399.26562.15.camel@host-140.engineering.n-able.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

I have a table that is purged by 25% each night. I'd like to do a
vacuum nightly after the purge to reclaim the space, but I think I'll
still need to do a vacuum full weekly.

Would there be any benefit to doing a cluster instead of the vacuum?

In response to

  • unsubscribe at 2005-09-20 18:41:30 from Nelba Sánchez Rojas

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Anu Kucharlapati 2005-09-21 01:44:54 Deadlock Issue with PostgreSQL
Previous Message Nelba Sánchez Rojas 2005-09-20 18:41:30 unsubscribe