Re: RE: Re: [ADMIN] v7.1b4 bad performance

From: Vadim Mikheev <vadim4o(at)email(dot)com>
To: Hannu Krosing <hannu(at)tm(dot)ee>, Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my>
Cc: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Schmidt, Peter" <peter(dot)schmidt(at)prismedia(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: RE: Re: [ADMIN] v7.1b4 bad performance
Date: 2001-02-22 14:40:09
Message-ID: 382990281.982852809809.JavaMail.root@web586-ec.mail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> It may be that WAL has changed the rollback
> time-characteristics to worse than pre-wal ?

Nothing changed ... yet. And in future rollbacks
of read-only transactions will be as fast as now,
anyway.

> > So my guess is that the 7.1 updates (with default
> > fsync) are significantly slower than 7.0.3 fsync=off
> > now.

Do you update tables with foreign keys?
Did you run tests in multi-user or single-user
environment?

Vadim

-----------------------------------------------
FREE! The World's Best Email Address @email.com
Reserve your name now at http://www.email.com

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Rini Dutta 2001-02-22 14:44:01 how critical is WAL ?
Previous Message He Weiping(Laser Henry) 2001-02-22 13:12:00 Chinese patch for Pgaccess