Re: Hot Standby and 64+ subxids (was COPY enhancements) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Hot Standby and 64+ subxids (was COPY enhancements)
Date
Msg-id 16276.1257822202@sss.pgh.pa.us
Whole thread Raw
In response to Re: Hot Standby and 64+ subxids (was COPY enhancements)  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
Andrew Dunstan <andrew@dunslane.net> writes:
> Simon Riggs wrote:
>> HS writes a WAL record for subtransactions at the point that the subxid
>> cache overflows for any single transaction. Current cache size = 64.
>> Top-level transaction then writes one additional WAL record every
>> additional 64 subxids after that. These are known as xid assignment
>> records.

> I don't recall seeing an answer to this, and I can't find one on the 
> list archives either. Is it no longer an issue?

I'm still concerned about it, but realistically the subxids would be
writing other WAL records too, so it's probably not as bad as I thought
at first.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: plpgsql EXECUTE will not set FOUND
Next
From: Tom Lane
Date:
Subject: Re: drop tablespace error: invalid argument