Re: [HACKERS] Slony-I goes BETA (possible bug)

From: Jeff Davis <jdavis-pgsql(at)empires(dot)org>
To: Jan Wieck <JanWieck(at)Yahoo(dot)com>
Cc: Slony-I Mailing List <slony1-general(at)gborg(dot)postgresql(dot)org>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, PostgreSQL advocacy <pgsql-advocacy(at)postgresql(dot)org>
Subject: Re: [HACKERS] Slony-I goes BETA (possible bug)
Date: 2004-06-07 18:33:58
Message-ID: 1086633238.13110.432.camel@jeff
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy pgsql-general pgsql-hackers

On Mon, 2004-06-07 at 06:20, Jan Wieck wrote:
> I tend to agree with you that spurious SYNC's aren't the end of the
> world. The idea of using notify to tell the syncThread somthing happened
> is probably the right way to do it, but at this time a little invasive.
> We need more time to investigate how to avoid notice storms during high
> update activity on the master.
>

There was discussion a while back about improving notify, and one
suggestion was to make it use shared memory so no disk writes are
involved (I believe the current implementation uses a table somehow). If
that was implemented, than we would have no problem with a notice storm,
right? It wouldn't use much shared memory since the slon daemon can
retrieve the notices just as fast as the backend can send them, right?

Backtracking a little, I'm still wondering how exactly a replicated
sequence is supposed to behave, do you have some comments about that? I
don't understand exactly why it's useful.

Regards,
Jeff

In response to

Responses

Browse pgsql-advocacy by date

  From Date Subject
Next Message Chris Browne 2004-06-07 20:21:48 Re: [HACKERS] Slony-I goes BETA (possible bug)
Previous Message Jan Wieck 2004-06-07 13:20:00 Re: [HACKERS] Slony-I goes BETA (possible bug)

Browse pgsql-general by date

  From Date Subject
Next Message Peter of the Norse 2004-06-07 19:31:01 Re: Updating a unique constrant
Previous Message Alexander S. 2004-06-07 18:11:33 bug in 7.4.2, concern unicode and russian content of db

Browse pgsql-hackers by date

  From Date Subject
Next Message Mario Weilguni 2004-06-07 19:51:12 Tool to read data files
Previous Message Andrew Dunstan 2004-06-07 17:09:04 Re: [HACKERS] Failures with windows port