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 по дате отправления:

Предыдущее
От: Michael Meskes
Дата:
Сообщение: Re: [HACKERS] latest parser changes
Следующее
От: John Holland
Дата:
Сообщение: Re: [HACKERS] Postgres Speed or lack thereof