vacuum vs pg_repack vs pg_reorg

From: sramay <nic(dot)srama(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: vacuum vs pg_repack vs pg_reorg
Date: 2014-12-29 12:42:18
Message-ID: 1419856938403-5832261.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have a database of size 1.5 TB. The attachments are stored in bytea.
The attachment table is consuming maximum space. The database version is
9.1.x and Streaming Replication is set. Now, I have to removed old records
to make way for new records without increasing SAN Space.

Which will be a better option

pg_repack - I have primary key on that table

or
Vacuum

or

pg_reorg

If you can suggest me a better option out of the above, It will simplify my
life. At any cost
streaming replication should not disturbed.

Regards

Ramachandran S

--
View this message in context: http://postgresql.nabble.com/vacuum-vs-pg-repack-vs-pg-reorg-tp5832261.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kevin Grittner 2014-12-29 15:00:11 Re: help troubleshooting invalid page header error
Previous Message Viktor Shitkovskiy 2014-12-29 07:28:01 Re: Rollback on include error in psql