>
> > >> So, if anybody reads from sl_log_status, it blocks until anything is
> > >written
> > >> to sl_log_status.
> > >It sounds like a way to make everything a lot slower.
> > Why? Where is the slowdown?
> If you have many slaves trying to read, they're all blocked.  This is
> effectively going to single-thread all the replicas.  It will be
> slower.

Hmmm... But in postgres read operations never blocks other operations (by
default) because of versioning. So, while all the replicas are blocked
waiting for a new event, they are still able to process a lot of read
queries coming from the site.

Or you mean that after unblocking ALL the replicas will simultaneously begin
to read new events from the Master and slow him down greatly? Please
detalize, it is not clear enough for me yet...

Thanks.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20070514/=
8fd64ebc/attachment.htm