RE: pre-beta is slow

From: "Mikheev, Vadim" <vmikheev(at)SECTORBASE(dot)COM>
To: "'Hannu Krosing'" <hannu(at)tm(dot)ee>
Cc: "'xuyifeng'" <jamexu(at)telekbird(dot)com(dot)cn>, pgsql-hackers(at)postgresql(dot)org
Subject: RE: pre-beta is slow
Date: 2000-12-08 19:11:02
Message-ID: 8F4C99C66D04D4118F580090272A7A234D31E3@sectorbase1.sectorbase.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> > > Try to compare 7.0.3 & 7.1beta in multi-user environment.
> >
> > As I understand it you claim it to be faster in multi-user
> > environment ?
> >
> > Could you give some brief technical background why is it so
> > and why must it make single-user slower ?
>
> Because of commit in 7.1 does fsync, with ot without -F
> (we can discuss and change this), but in multi-user env
> a number of commits can be made with single fsync.
> Seems I've described this before?

Ops, I forgot to answer question "why in single-user env 7.1 is
slower than 7.0.3?". I assumed that 7.1 was compared with 7.0.3
*with -F*, which probably is not correct, I don't know.
Well, the next test shows that 7.1 is faster in single-user env
than 7.0.3 *without -F*:

table (i int, t text); 1000 INSERTs (in separate transactions),
sizeof(t) 1 .. 256:

7.0.3: 42 sec -> 24 tps
7.1 : 24 sec -> 42 tps

Vadim

Browse pgsql-hackers by date

  From Date Subject
Next Message Mikheev, Vadim 2000-12-08 19:15:05 RE: pre-beta is slow
Previous Message Nathan Myers 2000-12-08 19:10:19 Re: CRC