Postgres Pro
Downloads
Home   >   mailing lists

VACUUM FULL vs CLUSTER - Mailing list pgsql-performance

From Markus Benne
Subject VACUUM FULL vs CLUSTER
Date
Msg-id 1127242399.26562.15.camel@host-140.engineering.n-able.com
Whole thread Raw
In response to unsubscribe  (Nelba Sánchez Rojas <nnsanche@puc.cl>)
Responses Re: VACUUM FULL vs CLUSTER
List pgsql-performance
Tree view 
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?

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: FW: Deadlock Issue with PostgreSQL
Next
From: "Ahmad Fajar"
Date:
Subject: tsearch2 seem very slow