3 edited tags
| link
2 edited title
| link

What is the impact of DROP SCHEMA on existing and continuing connectionsconcurrent read only workloads in PostgreSQL?

1
source | link

What is the impact of DROP SCHEMA on existing and continuing connections in PostgreSQL?

I have an ELT process that deals with a pretty small amount of data. I would like to have 1 schema called prod with the results of the previous ELT run and 1 schema called dev where I will perform the transformations of the current ELT run. Once the current ELT run is complete I would like to make the switch by running something along the lines of:

start transaction;
drop schema prod; 
alter schema dev rename to prod;
end transaction;

All queries issued outside of the ELT process are read only. How would MVCC handle this? What would happen to read only queries that were running when the drop schema command is issued? What would happen to read only queries issued after the drop schema command? What about after the end of the transaction?