max row size

From: Marc Tardif <admin(at)wtbwts(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: max row size
Date: 2000-01-24 13:38:30
Message-ID: Pine.BSF.4.10.10001241332010.35196-100000@server.b0x.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Jose Soares 2000-01-24 14:45:11 Re: [GENERAL] max(oid)
Previous Message J. Roeleveld 2000-01-24 13:23:34 System requirements