On Wed, 2006-07-12 at 12:43 -0400, Jan Wieck wrote:
> On 7/11/2006 12:43 PM, Christopher Browne wrote:
> 
> > I have set up tarballs for a first release candidate; Jan should be
> > uploading those soon, and I'll see about updating the web site when they
> > are uploaded...
> 
> I have run them through a compile and a few tests and uploaded them to 
> the usual location at
> 
> http://developer.postgresql.org/~wieck/slony1/download/
> 
> One thing I wanted to discuss is related to a recent discussion on the 
> hackers mailing list with respect to possible btree corruption due to 
> xxid not being suitable. With a single origin setup, there is not 

How about one partial index per node?

CREATE INDEX node5_xid_idx ON sl_log_1(log_xid) WHERE log_origin = 5;

This should give the performance benefits and prevent index rollover
problems.

Since you rotate sl_log_N structures, it should be possible to slip in
the index creation or destruction when you truncate the sl_log_N
structure.


--