Re: [HACKERS] performance test
От | Michael Meskes |
---|---|
Тема | Re: [HACKERS] performance test |
Дата | |
Msg-id | 19990119111301.A314@gmx.net обсуждение исходный текст |
Ответ на | Re: [HACKERS] performance test (Vadim Mikheev <vadim@krs.ru>) |
Список | 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 по дате отправления: