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.
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 |