Search Postgresql Archives

Re: Large Rows

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





On Wed, Oct 26, 2011 at 10:15 AM, Simon Riggs <simon@xxxxxxxxxxxxxxx> wrote:
On Wed, Oct 26, 2011 at 2:57 PM, Lee Hachadoorian
<lee.hachadoorian@xxxxxxxxx> wrote:

> Interesting. Although your example of one, 100000-dimension array works,
> five hundred 2-dimension arrays does not work. I can do the SELECT, but the
> CREATE TABLE fails:
>
> ERROR: row is too big: size 9024, maximum size 8160
> SQL state: 54000
>
> David has already hit the nail on the head in terms of this being a
> "political" problem rather than a technology problem. I'm open to ideas, but
> I realize there might be no other answer than "No one in their right mind
> should do this."

No, this is a technology problem.

Toast pointers are 20 bytes per column, so with 500 columns that is
10000 bytes - which will not fit in one block.

If you wish to fit this in then you should use a 2 dimensional array,
which will then be just 1 column and your data will fit.

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

Very useful to know. Thank you.

--Lee

--
Lee Hachadoorian
PhD, Earth & Environmental Sciences (Geography)
Research Associate, CUNY Center for Urban Research
http://freecity.commons.gc.cuny.edu/


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux