"FERREIRA, William (VALTECH)" <william.ferreira@xxxxxxxxxx> writes: > with PostgreSQL 8.1.3, here are my parameters (it's the default configuration) > wal_sync_method = fsync > wal_buffers = 8 > checkpoint_segments = 3 > bgwriter_lru_percent = 1.0 > bgwriter_lru_maxpages = 5 > bgwriter_all_percent = 0.333 > bgwriter_all_maxpages = 5 > and you think times can be improved again ? Increasing checkpoint_segments will definitely help for any write-intensive situation. It costs you in disk space of course, as well as the time needed for post-crash recovery. regards, tom lane
