[PERFORM] O_DIRECT setting

2004-09-20 Thread Guy Thornley
A recent comment on this (or perhaps another?) mailing list about Sun boxen and the directio mount option has prompted me to read about O_DIRECT on the open() manpage. Has anybody tried this option? Ever taken any performance measurements? I assume the way postgres manages its buffer memory

[PERFORM] vacuum full max_fsm_pages question

2004-09-20 Thread Patrick Hatcher
Hello. Couple of questions: - Q1: Today I decided to do a vacuum full verbose analyze on a large table that has been giving me slow performance. And then I did itagain. I noticed that after each run the values in my indexes and estimate row versionchanged. What really got me wondering