Re: pgsql: Fix confusion in SP-GiST between attribute type and leaf storage

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: Re: pgsql: Fix confusion in SP-GiST between attribute type and leaf storage
Date: 2021-04-05 02:27:39
Message-ID: YGp1m5VDdImLF8AC@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

On Sun, Apr 04, 2021 at 06:29:09PM +0000, Tom Lane wrote:
> Fix confusion in SP-GiST between attribute type and leaf storage type.

anole, woodstar and some other animals have been failing after this
commit:
https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=anole&dt=2021-04-04%2021%3A36%3A54

SELECT rank() OVER (ORDER BY p <-> point '123,456') n, p <-> point
'123,456' dist, id
FROM quad_poly_tbl WHERE p <@ polygon
'((300,300),(400,600),(600,500),(700,200))';
+ERROR: out of memory
+DETAIL: Failed on request of size 7688192 in memory context
"SP-GiST traversal-value context".

Tom, would dfc843d fix this issue? The buildfarm has not reported yet
with dfc843d, it seems.
--
Michael

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2021-04-05 02:41:15 Re: pgsql: Fix confusion in SP-GiST between attribute type and leaf storage
Previous Message Michael Paquier 2021-04-05 02:19:30 pgsql: Fix typo in collationcmds.c