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?