|Subject||RE: Insert into Large Table is slowly!|
The page isze is 16KB.
I'm not run gstat. I will try do it.
--- In email@example.com, <Sean@...> wrote:> I have 5-10 billions rows in table, and insert 50,000 rows every hour.What is your database page size?
> If so, I can not inactive index or spend a lot of time to reactive it.
Have you run gstat to look at the index stats for the table?