Re: Constant WAL replay

Joshua D. Drake wrote:
> >>
> >>Very close. We don't use the WAL (yet, slated for probably 8.1) but we
> >>do use a transaction log shipping method. So the implementation is 
> >>almost the same.
> > 
> > 
> > Can you run queries on the slave?  If so, how do you handle xid collisions?
> 
> You can run any query that does not modify data on a replicated table. 
> You can run any non data modifying query on any of the tables.

So, do you modify the slave to prevent it from grabbing an xid?

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073