Kevin Kempter wrote:
Hi List;
I have a very large table (52million rows) - I'm creating a copy of it to rid
it of 35G worth of dead space, then I'll do a sync, drop the original table
and rename table2.
Once I have the table2 as a copy of table1 what's the best way to select all
rows that have been changed, modified in table1 since the initial laod from
table1 into table2?
Also I'll need to delete any rows in table2 that no longer remain in table1.
Set log_statement to 'mod' (or 'ddl' if you expect any changes to the
schema itself) in postgresql.conf. Then it's just a matter of parsing
out the mods in the log.
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
