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.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2530 bytes
Desc: not available
Url : http://gborg.postgresql.org/pipermail/slony1-general/attachments/20060927/34d524e3/attachment.bin