Re: buffer busy wait for insert session


Perhaps, would be useful to have a look at what segments and type of
blocks are involved (P1&P2).

If your create_date column is a monotonically growing timestamp than
chances are that this index is the issue. The option would be to
recreate this index as REVERSE KEY and/or use hash partitioning as
Gopal noticed.
The same would be for PK if it's on monotonically increasing item_id column=

Best regards,
Alex Gorbachev

Other related posts: