From: | Michael Meskes <Michael(dot)Meskes(at)usa(dot)net> |
---|---|
To: | PostgreSQL Hacker <pgsql-hackers(at)postgreSQL(dot)org> |
Subject: | Re: [HACKERS] performance test |
Date: | 1999-01-19 10:13:01 |
Message-ID: | 19990119111301.A314@gmx.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(dot)Meskes(at)gmx(dot)net | Use PostgreSQL!
From | Date | Subject | |
---|---|---|---|
Next Message | Jose' Soares | 1999-01-19 12:30:37 | Re: [HACKERS] about RULES |
Previous Message | Michael Meskes | 1999-01-19 08:35:24 | Re: [HACKERS] latest parser changes |