Re: BUG #16694: Server hangs in 100% CPU loop when decompressing a specific TOAST Postgis linestring
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Tom Vijlbrief <tvijlbrief@gmail.com>
Cc: pgsql-bugs@lists.postgresql.org,
Tomas Vondra <tomas.vondra@2ndquadrant.com>
Date: 2020-11-02T15:02:54Z
Lists: pgsql-bugs
Tom Vijlbrief <tvijlbrief@gmail.com> writes: > Op ma 2 nov. 2020 om 00:45 schreef Tom Lane <tgl@sss.pgh.pa.us>: >> After looking at it some more, I'm pretty sure that these issues could >> explain your problem, though it's possible there's an additional >> contributing issue. If you're in a position to apply a patch and >> see whether it fixes the problem, please try >> https://git.postgresql.org/gitweb/?p=postgresql.git;a=patch;h=2330f4d3a87ac43b6ecd31bfd698384888ed03cb > Yes, this patch fixes the problem. Great, thanks for testing! regards, tom lane
Commits
-
Fix two issues in TOAST decompression.
- dfc797730fc7 14.0 landed
- 2330f4d3a87a 13.1 landed
-
Optimize partial TOAST decompression
- 11a078cf87ff 13.0 cited