Re: [HACKERS] Hot Standby and 64+ subxids (was COPY enhancements)

2009-11-09 Thread Tom Lane
Andrew Dunstan 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. T

Re: [HACKERS] Hot Standby and 64+ subxids (was COPY enhancements)

2009-11-09 Thread Andrew Dunstan
Simon Riggs wrote: On Thu, 2009-10-08 at 11:50 -0400, Tom Lane wrote: Robert Haas writes: Subcommitting every single row is going to be really painful, especially after Hot Standby goes in and we have to issue a WAL record after every 64 subtransactions (AIUI). Yikes ... I ha

[HACKERS] Hot Standby and 64+ subxids (was COPY enhancements)

2009-10-12 Thread Simon Riggs
On Thu, 2009-10-08 at 11:50 -0400, Tom Lane wrote: > Robert Haas writes: > > Subcommitting every single row is going to be really painful, > > especially after Hot Standby goes in and we have to issue a WAL record > > after every 64 subtransactions (AIUI). > > Yikes ... I had not been following t