[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