| Subject | Re: [firebird-support] What is the optimum pageSize? |
|---|---|
| Author | Mark Rotteveel |
| Post date | 2019-11-16T09:29:44Z |
On 16-11-2019 09:33, jerzyha@... [firebird-support] wrote:
rely on this maximum size (hint: the number itself fits in a 2-byte
unsigned integer). It is not like you just need to update a MAX_ROW_SIZE
constant and it is changed.
Consider that PostgreSQL has a limit of around 8KB (with its default
page size). However, PostgreSQL has the advantage that variable length
fields can be automatically stored out-of-line (ie basically as a blob,
but that is transparent to the user).
Mark
--
Mark Rotteveel
>Because it is hard to do. A lot of internals in Firebird and its clients
>>> But only for FB 2.5, not for FB3!
>>> My question was about FB3. Where is info about new versions?
>
>> In Release Notes for these versions.
>> Maximum size of record was not changed.
>
>
> This is a very big limitation, a few larger char fields with multibyte coding and we get an exception. I don't understand why this limitation hasn't been removed.
rely on this maximum size (hint: the number itself fits in a 2-byte
unsigned integer). It is not like you just need to update a MAX_ROW_SIZE
constant and it is changed.
Consider that PostgreSQL has a limit of around 8KB (with its default
page size). However, PostgreSQL has the advantage that variable length
fields can be automatically stored out-of-line (ie basically as a blob,
but that is transparent to the user).
> And in FB4 it is also 64 kB?Yes.
Mark
--
Mark Rotteveel