On Wed, 2004-10-27 at 18:23 -0600, Ed L. wrote:
> The databases I am replicating have around 200 sequences.  To replicate 
> these with slony or our modified dbmirror, that means we require 200 select 
> queries at every sync interval.

Um, I think you've somehow got this confused.

For us to replication sequences in our setup, all we require is adding
the sequences to the replication set in the same manner as the tables.

i.e.:

***********

# Add the public schema tables to the set
create set (id = 1, origin = 1, comment = 'The tables');

set add table (set id=1, origin=1, id=1, fully qualified name =
'public.first_table', comment='first table');

set add table (set id=1, origin=1, id=2, fully qualified name =
'public.second_table', comment='second table');

# Add the public schema sequences to the set
set add sequence (set id=1, origin=1, id=64, fully qualified name =
'public.first_seq', comment='first sequence');

set add sequence (set id=1, origin=1, id=65, fully qualified name =
'public.second_seq', comment='second sequence');

***********

No selecting of sequences is needed to cause them to propagate, they
"just do".

Does that make sense for you?

Regards and best wishes,

Justin Clift