| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Luis Amigo <lamigo(at)atc(dot)unican(dot)es> |
| Cc: | "Peter T(dot) Brown" <peter(at)memeticsystems(dot)com>, "'Jean Huveneers'" <j(dot)huveneers(at)farcourier(dot)com>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Maximum Performance Follow-up Question |
| Date: | 2002-01-24 19:27:28 |
| Message-ID: | 200201241927.g0OJRSS13819@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Luis Amigo wrote:
> I would keep an eye on backend's mem usage, don't let them get out of memory
> nor go to swap.
> I would consider increasing wal_files, i think postmaster is telling you every
> minute
Actually, checkpoint_segments is the critical parameter when you have
lots of activity and are checkpointing too often. wal_files is longer
significant because we reuse WAL files. I think it may be removed in
7.3 anyway. I want to add this information to hardware performance
tuning paper.
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Phill Kenoyer | 2002-01-24 20:12:28 | Re: What erd tool supports pgsql??/ |
| Previous Message | Zhang, Anna | 2002-01-24 19:21:07 | Re: Increasing Shared Memory - on MacOS X |