Ed L. pgsql
Fri Sep 24 16:07:47 PDT 2004
On Friday September 24 2004 8:53, Jan Wieck wrote:
> On 9/24/2004 10:12 AM, Ed L. wrote:
> > On Wednesday September 22 2004 8:42, Andrew Sullivan wrote:
> >> On Wed, Sep 22, 2004 at 06:19:50PM -0600, Ed L. wrote:
> >> > Hmm.  Adding 2 inserts for every update/delete/insert done by our
> >> > applications would not be good for our performance.
> >>
> >> You misunderstand.  It's not 2 inserts.  It's one into one of the
> >> tables, depending on which is active.
> >
> > The latest CVS code does 2 inserts by default.
>
> No, it does not. It only prepares the query plans for both log tables on
> the first call to the log trigger. You never see the real execution of
> saved SPI plans in the log.

Ah, I see I misread the new log style *and* the code.  Thx.

Ed



More information about the Slony1-general mailing list