On Sep 27, 2006, at 12:07 PM, Csaba Nagy wrote:
tables are small tables in your schema... but my schema has a few huge tables which are parents of foreign keys, and have lots of indexes. If the truncate fails on those tables, and the indexes are not dropped,then both the deletion and the copy will be an order of magnitude slower
next time i set up a replica i'll note which tables fail the truncate (I always wondered what the conditions for that were...) they are probably my smaller tables.
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
