Re: Decoding speculative insert with toast leaks memory
Amit Kapila <amit.kapila16@gmail.com>
From: Amit Kapila <amit.kapila16@gmail.com>
To: Dilip Kumar <dilipbalaut@gmail.com>
Cc: Andres Freund <andres@anarazel.de>,
Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>, Peter Eisentraut <peter.eisentraut@2ndquadrant.com>, Petr Jelinek <petr.jelinek@enterprisedb.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>, Tomas Vondra <tomas.vondra@enterprisedb.com>
Date: 2021-06-07T03:00:13Z
Lists: pgsql-hackers
On Wed, Jun 2, 2021 at 11:52 AM Amit Kapila <amit.kapila16@gmail.com> wrote: > > On Wed, Jun 2, 2021 at 11:38 AM Dilip Kumar <dilipbalaut@gmail.com> wrote: > > > > On Wed, Jun 2, 2021 at 11:25 AM Amit Kapila <amit.kapila16@gmail.com> wrote: > > > > > > I think the same relation case might not create a problem because it > > > won't find the entry for it in the toast_hash, so it will return from > > > there but the other two problems will be there. > > > > Right > > > > So, one idea could be > > > to just avoid those two cases (by simply adding return for those > > > cases) and still we can rely on toast clean up on the next > > > insert/update/delete. However, your approach looks more natural to me > > > as that will allow us to clean up memory in all cases instead of > > > waiting till the transaction end. So, I still vote for going with your > > > patch's idea of cleaning at spec_abort but I am fine if you and others > > > decide not to process spec_abort message. What do you think? Tomas, do > > > you have any opinion on this matter? > > > > I agree that processing with spec abort looks more natural and ideally > > the current code expects it to be getting cleaned after the change, > > that's the reason we have those assertions and errors. > > Okay, so, let's go with that approach. I have thought about whether it creates any problem in back-branches but couldn't think of any primarily because we are not going to send anything additional to plugin/subscriber. Do you see any problems with back branches if we go with this approach? > > OTOH I agree > > that we can just return from those conditions because now we know that > > with the current code those situations are possible. My vote is with > > handling the spec abort option (Option1) because that looks more > > natural way of handling these issues and we also don't have to clean > > up the hash in "ReorderBufferReturnTXN" if no followup change after > > spec abort. > > > > Even, if we decide to go with spec_abort approach, it might be better > to still keep the toastreset call in ReorderBufferReturnTXN so that it > can be freed in case of error. > Please take care of this as well. -- With Regards, Amit Kapila.
Commits
-
Fix ABI break introduced by commit 4daa140a2f.
- e95f617acc48 11.13 landed
- 72b51e214a2c 12.8 landed
- 56e366f6757d 13.4 landed
-
Fix valgrind issue in pgoutput.c.
- 357cb8f07f95 13.4 landed
-
Fix decoding of speculative aborts.
- 43acadfcebec 9.6.23 landed
- 35f56c124a7a 10.18 landed
- 1f8a934e0a86 11.13 landed
- 40ad7ebff6ca 12.8 landed
- 602a32a685e4 13.4 landed
- 4daa140a2f50 14.0 landed
-
pgoutput: Fix memory leak due to RelationSyncEntry.map.
- d2505681211b 13.4 cited
-
Fix initialization of RelationSyncEntry for streaming transactions.
- 69bd60672af6 14.0 cited
-
Implement streaming mode in ReorderBuffer.
- 7259736a6e5b 14.0 cited