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

From Michael Paquier
Subject Re: pgsql: Fix confusion in SP-GiST between attribute type and leaf storage
Date
Msg-id YGp1m5VDdImLF8AC@paquier.xyz
Whole thread Raw
In response to pgsql: Fix confusion in SP-GiST between attribute type and leaf storage  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pgsql: Fix confusion in SP-GiST between attribute type and leaf storage  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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

Attachment

pgsql-committers by date:

Previous
From: Michael Paquier
Date:
Subject: pgsql: Fix typo in collationcmds.c
Next
From: Tom Lane
Date:
Subject: Re: pgsql: Fix confusion in SP-GiST between attribute type and leaf storage