Re: copy and postgresql.conf

"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