Invalid mem alloc request on function

From: bima p <internetuser2013(at)gmail(dot)com>
To: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Invalid mem alloc request on function
Date: 2017-11-28 18:56:24
Message-ID: CAP8eoKq=OR6ith66D=mhXKvAhtkiLGtdyvGzdD7gKnytf3nf2A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Getting following error when running the pg_routing function. The text
value consists over 1.8gig is there something I can tweak to handle the
large size in function?

ERROR: invalid memory alloc request size 1080000000
CONTEXT: PL/=pgSQL function pgr_xxxx(text,anyarray,boolean) line 3 at
RETURN QUERY

B

Browse pgsql-performance by date

  From Date Subject
Next Message Alex Reece 2017-11-29 03:39:22 Re: Bad plan chosen for union all
Previous Message Alex Reece 2017-11-28 10:13:38 Bad plan chosen for union all