vacuum vs pg_repack vs pg_reorg

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.