Janardhan <jana-reddy@mediaring.com.sg> writes:
> Does it breaks any other things if all the index entries pointing the
> dead tuple are removed before reusing the dead tuple?.
Possibly you could make that work, but I think you'll find the
efficiency advantage you were chasing to be totally gone. The locking
scheme is heavily biased against you, and the index AMs don't offer an
API designed for efficient retail index-tuple deletion.
Of course that just says that you're swimming against the tide of
previous optimization efforts. But the thing you need to face up to
is you are taking what had been background maintenance tasks (viz,
VACUUM) and moving them into the foreground critical path. This *will*
slow down your foreground applications.
regards, tom lane