Subject Re: [firebird-support] Generators, what could cause resetting generator values to some earlier version
Author Paul Vinkenoog
Mark Rotteveel wrote:

> On 10-8-2012 18:20, Ann Harrison wrote:
> > Values for generators are stored densely on a page - depending on the page
> > size, somewhere between a lot and a whole lot fit on a page (4 bytes per
> > generator, 4-16K bytes per page, less page overhead).
>
> Wouldn't that be 8 bytes per generator these days?

Not just "these days", but in all versions of Firebird. The step from 32-bits to 64-bits values was taken in InterBase 6. Even in Dialect 1, generator values are 64 bits wide.

http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/generatorguide-basics.html#generatorguide-basics-maxval
http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/generatorguide-basics.html#generatorguide-basics-howmany


Cheers,
Paul Vinkenoog