Wed Sep 27 09:07:29 PDT 2006
- Previous message: [Slony1-general] Slony-I 1.2.0 RC4 Available
- Next message: [Slony1-general] Slony-I 1.2.0 RC4 Available
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
> i've not had this problem, and my DB is about 60Gb with many, many FK's. > > aren't FK's (rather, *all*) triggers disabled on the replica already? I don't know why you didn't have this problem, maybe you don't have indexes on the tables which are parents of foreign keys. Or the parent 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 than when I drop first the foreign keys (and then truncate succeeds and the indexes stay dropped during the copy). Cheers, Csaba.
- Previous message: [Slony1-general] Slony-I 1.2.0 RC4 Available
- Next message: [Slony1-general] Slony-I 1.2.0 RC4 Available
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list