Skip site navigation (1) Skip section navigation (2)

Re: Row Size

From: "Steve Wolfe" <steve(at)iboats(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Row Size
Date: 2000-04-27 21:17:33
Message-ID: 001e01bfb08e$00e0a470$85755ad1@iboats.com (view raw or flat)
Thread:
Lists: pgsql-general
> 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.

steve


In response to

  • Row Size at 2000-04-27 19:02:33 from gme

Responses

pgsql-general by date

Next:From: Roderick A. AndersonDate: 2000-04-27 21:57:37
Subject: Re: ODBC Stuff
Previous:From: Manuel LemosDate: 2000-04-27 21:09:49
Subject: Re: [SQL] US Date Style

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group