Basically where were doing an insert into <table> select * from dblink('dbname=olddb','select * from large_table) as t_large_table(table column listing);
Does anyone know of a way around this? The problem we were trying to solve is the fact that due to new column additions that are populated during the conversion, our db's are doubling in space. This is requiring lengthy vacuum fulls to reclaim the space and making for a very long conversion time.
We are very concerned that this system lockup could happen on our production boxes since we have several db's that are very large and probably have tables larger than our memory on the systems.
Anyway, any ideas on how to get around this, or how we might speed it up and not use so much space would be appreciated.
Chris
PG 7.3.4
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
