Re: restore time: sort_mem vs. checkpoing_segments

From: Vivek Khera <khera(at)kcilink(dot)com>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: restore time: sort_mem vs. checkpoing_segments
Date: 2003-09-23 14:27:55
Message-ID: 16240.22635.390707.785148@yertle.int.kciLink.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

>>>>> "BM" == Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:

BM> restore, even if there is no value to it being large during normal
BM> server operation. Should that be decumented?

Yes, right alongside the recommendation to bump sort_mem, even though
in my tests sort_mem made no significant difference in restore time
going from 8m to 128m.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Garrett Bladow 2003-09-24 00:24:26 LIKE query running slow
Previous Message Bruce Momjian 2003-09-23 13:59:01 Re: restore time: sort_mem vs. checkpoing_segments