The declare'd statement which finds the 2000 or so statements within a
"snapshot" seems to take a little over a minute to FETCH the first 100
entries. Statement attached.

The query itself isn't that bad, it's just that the log_xid range is
about 200000 transactions wide, which means it has to sift through a
fair amount of data to get what it's looking for.

Is it possible to get slony to deal with 10 or 100 snapshots at a time
rather than just 1 when it's trying to catch up?
-------------- next part --------------
A non-text attachment was scrubbed...
Name: slowquery.sql
Type: text/x-sql
Size: 2197 bytes
Desc: not available
Url : http://gborg.postgresql.org/pipermail/slony1-general/attachments/20041110/338ed287/slowquery.bin