Re: Results of testing WAL

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Mikheev, Vadim" <vmikheev(at)SECTORBASE(dot)COM>
Cc: "'pgsql-hackers(at)postgresql(dot)org'" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Results of testing WAL
Date: 2000-11-10 04:15:11
Message-ID: 9394.973829711@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Mikheev, Vadim" <vmikheev(at)SECTORBASE(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message The Hermit Hacker 2000-11-10 04:16:38 Re: 7.0.2 dies when connection dropped mid-transaction
Previous Message Tom Lane 2000-11-10 04:09:16 Re: 7.0.2 dies when connection dropped mid-transaction