"FERREIRA, William (VALTECH)" <william.ferreira@airbus.com> 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
