> I need a tuple with 50k in size. I already know how to
> change the size and make it bigger. But I'm not sure
> about the maximum size it supports. Does anyone ever
> used a row size greater than 32k?
From the TOAST page (http://www.postgresql.org/projects/devel-toast.html),
"The PostgreSQL database system has a very old, deeply hardwired
limitation. It is the fact, that each row of every table must fit into the
on-disk blocksize, which is 8K by default. Unfortunately, changing the
blocksize has a number of unwanted side effects, and currently blocksizes
are limited to a maximum of 32K. So this cannot be the solution. "
You'll have to use long objects, or the TOAST stuff.
In response to
- Row Size at 2000-04-27 19:02:33 from gme
pgsql-general by date
|Next:||From: Roderick A. Anderson||Date: 2000-04-27 21:57:37|
|Subject: Re: ODBC Stuff|
|Previous:||From: Manuel Lemos||Date: 2000-04-27 21:09:49|
|Subject: Re: [SQL] US Date Style|