Re: [HACKERS] performance test
| От | Vadim Mikheev |
|---|---|
| Тема | Re: [HACKERS] performance test |
| Дата | |
| Msg-id | 36A4227A.BD961413@krs.ru обсуждение исходный текст |
| Ответ на | Re: [HACKERS] performance test (Bruce Momjian <maillist@candle.pha.pa.us>) |
| Список | pgsql-hackers |
Bruce Momjian 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. > > Is this idea still reasonable? > > --------------------------------------------------------------------------- > > Here is an archive of the pg_log discussion. Thanks for archive, Bruce. But delayed fsync is another idea. bufmgr has to be fixed anyway. Vadim
В списке pgsql-hackers по дате отправления: