| 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: | Whole Thread | Raw Message | 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 |