| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Mark kirkwood <markir(at)slingshot(dot)co(dot)nz> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Fsync on/off For Various Filesystems/Platforms (Ending |
| Date: | 2002-03-09 21:00:04 |
| Message-ID: | 200203092100.g29L04106330@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Mark kirkwood wrote:
> Damn... too quick with the "send" button.
>
> I forgot to mention :
>
> 1) the test involved usng copy to load the rows !
Oh, COPY. Remember fsync of WAL only happens at the end of a
transaction, and with COPY, that is only once the table is completely
loaded. No wonder you saw strange results. Also, someone reported ext3
as 50% slower than ext2, so again, your numbers are a surprise.
--
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 | Thomas Lockhart | 2002-03-09 22:06:18 | Re: UNIQUE( col1, col2 ) creates what indexes? |
| Previous Message | Rob Hoopman | 2002-03-09 19:03:15 | Re: UNIQUE( col1, col2 ) creates what indexes? |