Heikki Linnakangas <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings