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
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 |