Re: BUG #7756: When upgrading postgis extension get row is too big: size 9272, maximum size 8160 - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #7756: When upgrading postgis extension get row is too big: size 9272, maximum size 8160
Date
Msg-id 26090.1355761524@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #7756: When upgrading postgis extension get row is too big: size 9272, maximum size 8160  (Andres Freund <andres@2ndquadrant.com>)
Responses Re: BUG #7756: When upgrading postgis extension get row is too big: size 9272, maximum size 8160
List pgsql-bugs
Andres Freund <andres@2ndquadrant.com> writes:
> On 2012-12-17 10:06:53 -0500, Paragon Corporation wrote:
>> 2012-12-17 09:15:15 EST ERROR:  54000: row is too big: size 9272, maximum
>> size 8160

> Unfortunately that doesn't tell us very much. Could you get a backtrace
> for that? I don't really see which table should receive such large
> tuples...

Hm ... pg_extension does not have a TOAST table.  Could the extconfig
and extcondition fields be getting bloated unreasonably?  If I
understand the scenario here, this would require (1) the extension
contains a configuration table (probably one with a filter condition)
and (2) for some reason the repeated updates are adding, not replacing,
entries for the table in these columns.

If that's the story it would be easy to verify by watching the
extension's pg_extension entry as you repeatedly upgrade it.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Paragon Corporation"
Date:
Subject: Re: BUG #7756: When upgrading postgis extension get row is too big: size 9272, maximum size 8160
Next
From: "Paragon Corporation"
Date:
Subject: Re: BUG #7756: When upgrading postgis extension get row is too big: size 9272, maximum size 8160