>>>>> "TL" == Tom Lane <tgl@sss.pgh.pa.us> writes:
TL> Vivek Khera <khera@kcilink.com> writes:
>> Ditto for me. Can you reproduce my results by increasing
>> checkpoint_buffers to some large value (I use 50)?
TL> You meant checkpoint_segments, right? It might be interesting to
TL> experiment with wal_buffers, too, though I'm not convinced that will
TL> have a big impact.
The difference on restore with fsync=false was 2 seconds. I'm
rebuilding PG with Marc's WAL-disabling patch and will see the change
there.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: khera@kciLink.com Rockville, MD +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/