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$ (view raw, whole thread or download thread mbox)
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 (,

"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. 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-2018 The PostgreSQL Global Development Group