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

  1. Fix two issues in TOAST decompression.

  2. Optimize partial TOAST decompression