Subject RE: Insert into Large Table is slowly!

The page isze is 16KB.

I'm not run gstat. I will try do it.


--- In, <Sean@...> wrote:

> I have 5-10 billions rows in table, and insert 50,000 rows every hour.
> If so, I can not inactive index or spend a lot of time to reactive it.
> thanks.

What is your database page size?

Have you run gstat to look at the index stats for the table?