Re: postgres limitation -what does it mean? (8k row limit) - Mailing list pgsql-general

From Matt Friedman
Subject Re: postgres limitation -what does it mean? (8k row limit)
Date
Msg-id 002f01c0881a$1c52f5a0$e8804318@mattq3h8budilr
Whole thread Raw
In response to Re: postgres limitation  (The Hermit Hacker <scrappy@hub.org>)
List pgsql-general
I've been following this thread but it's not clear to me what an 8k row
limit means exactly.

Does it mean that the size of all the data in that row must not be greater
than 8k? That seems very small to me.

Also, how does one change BLCKSZ?

Some more detail on the subject would be great. thank you.

Matt Friedman




----- Original Message -----
From: "Mitch Vincent" <mitch@venux.net>
To: <pgsql-general@postgresql.org>
Sent: Friday, January 26, 2001 7:28 PM
Subject: Re: postgres limitation


> > > the max size of a row...
> >
> > 8k in pre v7.1, no limit in v7.1 an dlater ...
>
> 32k really... BLCKSZ can be changed.. I've had no trouble running a
> production database with BLCKSZ set to 32k though there might be issues
I'm
> not aware of..
>
> -Mitch
>
>
>


pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Unique ID of connection
Next
From: Franck Martin
Date:
Subject: ISO SQL Geographic Objects