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.