[Slony1-general] Order of "set add table" on speed

Sung Hsin Lei sungh.lei at gmail.com
Wed Jan 26 20:20:22 UTC 2022


Hi,

Does the order of the "set add table" matter for the speed of the initial
replication?

If I have tables "emails" which depends on "partitions" which depends on
"accounts",
is there a difference between:

set add table (set id=1, origin=1, id=1, fully qualified name =
'public.emails  ', comment= 'emails  table');
set add table (set id=1, origin=1, id=2, fully qualified name =
'public.partitions  ', comment= 'partitions  table');
set add table (set id=1, origin=1, id=3, fully qualified name =
'public.accounts  ', comment= 'accounts  s table');

and

set add table (set id=1, origin=1, id=1, fully qualified name =
'public.accounts  ', comment= 'accounts  table');
set add table (set id=1, origin=1, id=2, fully qualified name =
'public.partitions  ', comment= 'partitions  table');
set add table (set id=1, origin=1, id=3, fully qualified name =
'public.emails  ', comment= 'emails   table');


?


Thanks

Sung
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.slony.info/pipermail/slony1-general/attachments/20220126/c0cbd862/attachment.htm>


More information about the Slony1-general mailing list