Re: State of Beta 2

From: Vivek Khera <khera(at)kcilink(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: State of Beta 2
Date: 2003-09-24 15:14:00
Message-ID: x7n0cucj7r.fsf@yertle.int.kciLink.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>>>>> "TL" == Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

TL> Vivek Khera <khera(at)kcilink(dot)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(at)kciLink(dot)com Rockville, MD +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Josué Maldonado 2003-09-24 15:18:01 Re: Is this "order by" logic right
Previous Message Pavel Stehule 2003-09-24 15:10:37 Re: Accessing tables from different databases