max row size - Mailing list pgsql-general

From Marc Tardif
Subject max row size
Date
Msg-id Pine.BSF.4.10.10001241332010.35196-100000@server.b0x.com
Whole thread Raw
List pgsql-general
I would like to use the max row size to store data instead of using the
blob data type. From the FAQ, I understand each row must not cross 8k
boundaries so the actual data must stay below 5k.

1. Is 5k litteral, ie exactly 5120 bytes?

2. In this situation, would it be preferable to use the text datatype and
make sure the total size is <5k or use a varchar(5120)?

Marc


pgsql-general by date:

Previous
From: Alex Guryanow
Date:
Subject: uninterruptible sleep
Next
From: Lamar Owen
Date:
Subject: Re: installation with RH RPM v6.5.2 postmaster hangs