Vacuum full: alternatives?

From: Job <Job(at)colliniconsulting(dot)it>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Vacuum full: alternatives?
Date: 2016-06-20 09:18:13
Message-ID: 88EF58F000EC4B4684700C2AA3A73D7A07682A61343E@W2008DC01.ColliniConsulting.lan
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

we have a table with an heavy traffic of pg_bulkload and delete of records.
The size pass, in only one day, for example for 1Gb to 4Gb and then 1Gb back.

We have important problems on size and the only way to gain free space is issueing a vacuum full <table>.
But the operation is very slow, sometimes 2/4 hours, and table is not available for services as it is locked.

We do not delete everything at one (in this case the truncate woudl resolve the problem).

The autovacuum is not able (same for normal vacuum) to free the spaces.

Are there some suggestions or another way to manage this?

Thank you!
Francesco

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rakesh Kumar 2016-06-20 09:34:24 Re: Vacuum full: alternatives?
Previous Message Tatsuro Yamada 2016-06-20 01:40:36 Re: Pg_bulkload for PostgreSql 9.5