Excerpts from Hans-Jürgen Schönig's message of lun oct 04 07:02:04 -0400 2010:
> i tracked down the issue quickly and make the following profile (in 10k locks
> or so):
>
> Flat profile:
>
> Each sample counts as 0.01 seconds.
> % cumulative self self total
>
On Oct 4, 2010, at 1:23 PM, Heikki Linnakangas wrote:
> On 04.10.2010 14:02, Hans-Jürgen Schönig wrote:
>> it seems we have found a fairly nasty problem.
>> imagine a long transaction which piles up XX.XXX of locks (count on
>> pg_locks) inside the same transaction by doing some tasty savepoints,
On 04.10.2010 14:02, Hans-Jürgen Schönig wrote:
it seems we have found a fairly nasty problem.
imagine a long transaction which piles up XX.XXX of locks (count on pg_locks)
inside the same transaction by doing some tasty savepoints, with hold cursors
and so on.
in this case we see that a normal
hello all ...
it seems we have found a fairly nasty problem.
imagine a long transaction which piles up XX.XXX of locks (count on pg_locks)
inside the same transaction by doing some tasty savepoints, with hold cursors
and so on.
in this case we see that a normal count issued in a second database
