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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
