Re: Results of testing WAL - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Results of testing WAL
Date
Msg-id 9394.973829711@sss.pgh.pa.us
Whole thread Raw
In response to Results of testing WAL  ("Mikheev, Vadim" <vmikheev@SECTORBASE.COM>)
List pgsql-hackers
"Mikheev, Vadim" <vmikheev@SECTORBASE.COM> writes:
> Results: 5000 transactions took ~60 sec in 7.1, ~550 sec in 7.0.2 with fsync
> and ~60 sec without fsync.

> So, seems that WAL added not just complexity to system -:)

Sounds great!

> I'm going to commit redo for sequences tomorrow evening and
> #define XLOG by default after this (initdb will be required).

I suggest bumping the catversion.h number when you #define XLOG,
so that people won't be able to accidentally start an old postmaster
with new DB or vice versa.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: 7.0.2 dies when connection dropped mid-transaction
Next
From: The Hermit Hacker
Date:
Subject: Re: 7.0.2 dies when connection dropped mid-transaction