"FERREIRA, William (VALTECH)" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
