Re: 8.1beta, SunOS and shmget

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Heikki Linnakangas <hlinnaka(at)iki(dot)fi>
Cc: "Sergey E(dot) Koposov" <math(at)sai(dot)msu(dot)ru>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: 8.1beta, SunOS and shmget
Date: 2005-08-29 17:28:22
Message-ID: 11075.1125336502@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Heikki Linnakangas <hlinnaka(at)iki(dot)fi> writes:
> On Mon, 29 Aug 2005, Tom Lane wrote:
>> Yes; mostly from 2PC support I think. Try reducing
>> max_prepared_transactions. (We might want to debate whether the default
>> setting should be smaller than 50 --- it looks to me like that's adding
>> over 700K to the default shared memory block size.)

> In fact, 0 might be reasonable default. Not many people need 2PC.

Good point, but if we set it to 0 then the prepared-xacts regression
test won't work. We could set it to just enough to run the test,
say five or ten.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2005-08-29 17:32:22 Re: 8.1beta, SunOS and shmget
Previous Message Heikki Linnakangas 2005-08-29 17:05:49 Re: 8.1beta, SunOS and shmget