row is too big: size 8168, maximum size 8160

From: Mario De Frutos Dieguez <mariodefrutos(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: row is too big: size 8168, maximum size 8160
Date: 2018-07-11 14:16:43
Message-ID: CAFYwGJ0Sphm9m3noXMgYf=1iDCn1=V2+7+VCD-nRg+C21Ee-gA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello every one!

I've found this error message and it's driving me crazy.

I have a table with 790 numeric columns, I'm trying to make an INSERT INTO
x SELECT... and in the same column/s I'm getting this message.

I've tried everything VACUUM FULL, Batch the insert with updates...but
nothing always the same error.

THe BLCKSZ is set to 8Kb here:
https://github.com/postgres/postgres/blob/master/src/include/pg_config.h.in#L36
but I'm suspecting that this or corrupted data or something I'm missing.

I've also read about TOAST-able and so on and I haven't messed with storage
properties. The data into that columns aren't big numbers (maybe having
many decimal counts)

Any clues? help?

Thank you

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Mariel Cherkassky 2018-07-11 14:19:43 Re: invalid value for parameter "client_encoding": "ISO_8859_8"
Previous Message Mariel Cherkassky 2018-07-11 14:12:50 Re: wal exist in slave but getting err requested WAL segment has already been removed