On Wednesday, April 10, 2013, Nik Tek wrote:
> Hi Bambi,
>
> Thank you the prompt reply.
>
> This table is very volatile, lot of inserts/updates happen on this
> tables(atleast 20~30 inserts/min).
>
That number of inserts per minute is not all that many. I suspect that you
have sessions which ar
On Thursday, April 11, 2013, Tom Lane wrote:
>
> [ pokes around ... ] You certain 9.2.3 didn't do this too? This
> appears to be an intentional behavior of the 9.2.3 patch that made it
> cancel truncation when there were conflicting lock requests:
>
> /*
> * Report results to the stats