Re: [HACKERS] performance test - Mailing list pgsql-hackers

From Michael Meskes
Subject Re: [HACKERS] performance test
Date
Msg-id 19990119111301.A314@gmx.net
Whole thread Raw
In response to Re: [HACKERS] performance test  (Vadim Mikheev <vadim@krs.ru>)
List pgsql-hackers
On Tue, Jan 19, 1999 at 10:27:50AM +0700, Vadim Mikheev wrote:
> You've seen disadvantages of our unperfect buffer manager -:)
> When server need in buffer for new data comming and there is
> no unused buffers in pool (i.e. - all buffers filled with new
> data and marked as dirty), server gets some dirty buffer,
> writes it AND FSYNC file. So, server does many fsyncs
> even with BEGIN/END while should do _one_ fsync at COMMIT.
> 
> Having this problem fixed you wouldn't had so big difference
> between -F and BEGIN/END-no-F.

I see. But without BEGIN/END a huge difference remains to be expected,
doesn't it?

Michael
-- 
Michael Meskes                         | Go SF 49ers!
Th.-Heuss-Str. 61, D-41812 Erkelenz    | Go Rhein Fire!
Tel.: (+49) 2431/72651                 | Use Debian GNU/Linux!
Email: Michael.Meskes@gmx.net          | Use PostgreSQL!


pgsql-hackers by date:

Previous
From: Michael Meskes
Date:
Subject: Re: [HACKERS] latest parser changes
Next
From: John Holland
Date:
Subject: Re: [HACKERS] Postgres Speed or lack thereof