Subject Re: [firebird-support] Fb1.5 RC7 CS: Pointer page vanished from DPM_next (249);
Author Helen Borrie
At 12:37 PM 12/01/2004 +0100, you wrote:
>Dear,
>
>On Mon, 12 Jan 2004 22:27:17 +1100,
>Helen Borrie wrote :
>
> > The vanished index pointer page looks to be at least one source
> > of/indicator of your problems. I would want to drop that PK constraint
> > until after you have loaded the data. The index is probably a
> nightmare of
> > imbalance. And i really WOULD want that row_key to be a 64-bit integer.
>
>Four times roughly 450 millions rows.

Yep, missed that.

>And maybe another bag of some millions that gbak didn't reported
>because it stopped on the error report before emitting the "records
>written" message.

Looping? Notice the numbers incrementing by 20,000 each time? I dunno
what it means but it looks a bit spooky.


>This looks like there are close to 2 x 10^9 rows, which is close to
>2^(32-1).
>
>Don't we hit a system limit on 2^31 rows ?

About. IB docs say 2^32 but it's probably less.

/h