Re: RE: Re: [ADMIN] v7.1b4 bad performance - Mailing list pgsql-hackers

From Vadim Mikheev
Subject Re: RE: Re: [ADMIN] v7.1b4 bad performance
Date
Msg-id 382990281.982852809809.JavaMail.root@web586-ec.mail.com
Whole thread Raw
List 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




pgsql-hackers by date:

Previous
From: "Jeff Lu"
Date:
Subject: undefined reference pq
Next
From: Rini Dutta
Date:
Subject: handling of database size exceeding physical disk space