rfc: DROP column and replication impact

From: gleeco <gleeco(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: rfc: DROP column and replication impact
Date: 2017-08-03 16:06:24
Message-ID: CADv14s8ugbPKQaY5CxQxQp8OGnqusVVcUHMmjgB7n5vMcHQuQQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

hello - we're excited to be making a change to drop an insane wide column
that is pg_toast table > 10T. The question is: what kind of fallout/impact
to expect for auto-vacuum and replication after `DROP COLUMN xxx`.

This is a 9.3 cluster w/ multiple of read replicas; > 1k tx/sec; and 2
wal log/sec

thanks in advance!

-gleeco

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2017-08-03 22:04:58 Re: rfc: DROP column and replication impact
Previous Message amandeep singh 2017-08-03 08:05:38 Re: Terminate connections using non-superuser