Re: buffer busy wait for insert session

  • From: Alex Gorbachev <gorbyx@xxxxxxxxx>
  • To: zhuchao@xxxxxxxxx
  • Date: Fri, 20 May 2005 21:00:48 +0200


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: