Postgres Pro
Downloads
Home   >   mailing lists

[ADMIN] rfc: DROP column and replication impact - Mailing list pgsql-admin

From gleeco
Subject [ADMIN] rfc: DROP column and replication impact
Date
Msg-id CADv14s8ugbPKQaY5CxQxQp8OGnqusVVcUHMmjgB7n5vMcHQuQQ@mail.gmail.com
Whole thread Raw
Responses Re: [ADMIN] rfc: DROP column and replication impact  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: amandeep singh
Date:
Subject: Re: [ADMIN] Terminate connections using non-superuser
Next
From: Tom Lane
Date:
Subject: Re: [ADMIN] rfc: DROP column and replication impact