| Subject | Re: [firebird-support] "index root page is full" error populating temp table |
|---|---|
| Author | Ann Harrison |
| Post date | 2011-02-25T15:49:42Z |
On Thu, Feb 24, 2011 at 9:46 PM, Ken Coffman <
ken.coffman@...> wrote:
Firebird has a long standing limit that the definitions of all indexes for a
table must fit on a single database page. The actual limit on the number
of indexes depends not just on the page size, but also on teh complexity
of the index definitions.
The limit goes back to 1984 (Orwellian) and increases in the maximum
allowed page size have sort of hidden it. When I asked about adding more
index root pages to tables in the late 80's, the response was tha no one
should ever need more indexes than can be described in 4000 bytes.
Now the limit is closer to 16,000 bytes.
Good luck,
Ann
[Non-text portions of this message have been removed]
ken.coffman@...> wrote:
>The solution is to increase your page size.
> DB Page Size:
>
> 4096
>
> Unfortunately with larger customer databases we have found the first stored
> proc fails after a minute with this error:
>
> ISC ERROR MESSAGE:
> unsuccessful metadata update
> cannot add index, index root page is full.
>
> The point at which this occurs seems to vary between test platforms.
>
Firebird has a long standing limit that the definitions of all indexes for a
table must fit on a single database page. The actual limit on the number
of indexes depends not just on the page size, but also on teh complexity
of the index definitions.
The limit goes back to 1984 (Orwellian) and increases in the maximum
allowed page size have sort of hidden it. When I asked about adding more
index root pages to tables in the late 80's, the response was tha no one
should ever need more indexes than can be described in 4000 bytes.
Now the limit is closer to 16,000 bytes.
Good luck,
Ann
[Non-text portions of this message have been removed]