Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group