Re: [BUGS] Gin Index Creation Failure - Mailing list pgsql-bugs

From Tom Lane
Subject Re: [BUGS] Gin Index Creation Failure
Date
Msg-id 9754.1503936052@sss.pgh.pa.us
Whole thread Raw
In response to [BUGS] Gin Index Creation Failure  (Yaser Raja <yrraja@gmail.com>)
List pgsql-bugs
Yaser Raja <yrraja@gmail.com> writes:
> While creating a gin index in Postgres 9.5.8 I got the following error
> message:
>     ERROR:  invalid memory alloc request size 2013265920
> After a number of attempts to independently reproduce this issue, i have
> found that this error comes up when the following conditions are met:
>    - Table contains more than 200M rows
>    - The maintenance_work_mem is around 1GB or higher
> ...
> I was not able to reproduce this issue in Postgres 9.6.4.

Yeah, this appears to have been fixed in commit 30bb26b5e, which was
not back-patched.
        regards, tom lane


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

pgsql-bugs by date:

Previous
From: Yaser Raja
Date:
Subject: [BUGS] Gin Index Creation Failure
Next
From: Robert Haas
Date:
Subject: Re: [HACKERS] [BUGS] [postgresql 10 beta3] unrecognized node type: 90