Re: further testing on IDE drives - Mailing list pgsql-performance

From Vivek Khera
Subject Re: further testing on IDE drives
Date
Msg-id 16266.43541.10798.861464@yertle.int.kciLink.com
Whole thread Raw
In response to Re: further testing on IDE drives  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-performance
>>>>> "BM" == Bruce Momjian <pgman@candle.pha.pa.us> writes:

BM> COPY only does fsync on COPY completion, so I am not sure there are
BM> enough fsync's there to make a difference.


Perhaps then it is part of the indexing that takes so much time with
the WAL.  When I applied Marc's WAL disabling patch, it shaved nearly
50 minutes off of a 4-hour restore.

I sent to Tom the logs from the restores since he was interested in
figuring out where the time was saved.

pgsql-performance by date:

Previous
From: Shridhar Daithankar
Date:
Subject: Re: Another weird one with an UPDATE
Next
From: ingrim
Date:
Subject: unsuscribe mailing list