| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "FERREIRA, William (VALTECH)" <william(dot)ferreira(at)airbus(dot)com> |
| Cc: | J(dot)K(dot)Shah(at)Sun(dot)COM, Albert Cervera Areny <albert(at)sedifa(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: copy and postgresql.conf |
| Date: | 2006-02-15 15:18:18 |
| Message-ID: | 196.1140016698@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
"FERREIRA, William (VALTECH)" <william(dot)ferreira(at)airbus(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Antal Attila | 2006-02-15 15:51:47 | Stored proc and optimizer question |
| Previous Message | Jignesh K. Shah | 2006-02-15 15:07:02 | Re: copy and postgresql.conf |