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

From: "Matt Friedman" <matt(at)daart(dot)ca>
To: "Mitch Vincent" <mitch(at)venux(dot)net>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: postgres limitation -what does it mean? (8k row limit)
Date: 2001-01-27 04:32:08
Message-ID: 002f01c0881a$1c52f5a0$e8804318@mattq3h8budilr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)venux(dot)net>
To: <pgsql-general(at)postgresql(dot)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
>
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Franck Martin 2001-01-27 04:33:37 ISO SQL Geographic Objects
Previous Message Alex Pilosov 2001-01-27 04:20:10 Re: Too many open files! how do I fix on linux?