On Thu, 2009-02-12 at 09:50 +0200, Heikki Linnakangas wrote: > It occurs to me that we don't need this patch for hot standby if we > abuse the main xid array (SnapshotData.xip) to store the unobserved xids > instead of the subxid array. That one is always scanned in > XidInMVCCSnapshot. I think we should do that rather than try to salvage > this patch.
I think my proposal still holds water, but I also think it is probably time to say OK, let's make this simpler and take the subxid tuning off line. We would need to increase the max size of the xip array by 2*max_connections. So an increase of 80kB on normal running, which I can accept. Is that the only change you are suggesting to resolve this? I hope so. -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers