| From: | Mark Kirkwood <markir(at)paradise(dot)net(dot)nz> |
|---|---|
| To: | Euler Taveira de Oliveira <eulerto(at)yahoo(dot)com(dot)br> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: row is too big: size 8916, maximum size 8136 |
| Date: | 2005-12-07 05:39:02 |
| Message-ID: | 43967576.9050507@paradise.net.nz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Euler Taveira de Oliveira wrote:
> Hi,
>
> I'm doing some tests with a 700 columns' table. But when I try to load
> some data with INSERT or COPY I got that message. I verified that the
> BLCKZ is limiting the tuple size but I couldn't have a clue why it's
> not using TOAST. I'm using PostgreSQL 8.0.3 in Slackware 10.1 box.
> Let me know if you want a test case or other useful information.
>
>
700 columns - yuck... recompiling with BLCKSZ=16384 or 32768 (say) might
allow you this many ....(will require an initdb).
regards
Mark
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Markus Schiltknecht | 2005-12-07 07:42:55 | Re: Replication on the backend |
| Previous Message | Gregory Maxwell | 2005-12-07 05:09:03 | Re: Replication on the backend |