From: | Vivek Khera <khera(at)kcilink(dot)com> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Determine optimal fdatasync/fsync, O_SYNC/O_DSYNC options |
Date: | 2004-09-14 18:19:33 |
Message-ID: | x7u0u0u30q.fsf@yertle.int.kciLink.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
>>>>> "TL" == Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
TL> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
>> If we had a majority of queries filling more than one block we would
>> be checkpointing like crazy and we don't normally get reports about
>> that.
TL> [ raised eyebrow... ] And of course the 30-second-checkpoint-warning
TL> stuff is a useless feature that no one ever exercises.
Well, last year about this time I discovered in my testing I was
excessively checkpointing; I found that the error message was
confusing, and Bruce cleaned it up. So at least one person excercised
that feature, namely me. :-)
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: khera(at)kciLink(dot)com Rockville, MD +1-301-869-4449 x806
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/
From | Date | Subject | |
---|---|---|---|
Next Message | aaron werman | 2004-09-14 18:20:50 | Re: Data Warehouse Reevaluation - MySQL vs Postgres -- merge tables |
Previous Message | Jeffrey W. Baker | 2004-09-14 18:11:38 | Re: disk performance benchmarks |