Re: State of Beta 2 - Mailing list pgsql-general

From Vivek Khera
Subject Re: State of Beta 2
Date
Msg-id x7n0cucj7r.fsf@yertle.int.kciLink.com
Whole thread Raw
In response to Re: State of Beta 2  (Andrew Rawnsley <ronz@ravensfield.com>)
List pgsql-general
>>>>> "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/

pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Accessing tables from different databases
Next
From: Josué Maldonado
Date:
Subject: Re: Is this "order by" logic right