Re: An example of bugs for Hot Standby - Mailing list pgsql-hackers

From Hiroyuki Yamada
Subject Re: An example of bugs for Hot Standby
Date
Msg-id 200912181113.AA00178@silver.kokolink.net
Whole thread Raw
In response to Re: An example of bugs for Hot Standby  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: An example of bugs for Hot Standby  (Hiroyuki Yamada <yamada@kokolink.net>)
List pgsql-hackers
>This way we only cancel direct deadlocks.
>
>It doesn't solve general problem of buffer waits, but they may be
>solvable by different mechanism.
>

Following question may be redundant. Just a confirmation.

Deadlock example is catstrophic while it's rather a rare event.
On the other hand, LockBufferForCleanup() can cause another 
problem.
* One idle pin-holder backend can freeze startup process().

This problem is not catstrophic, but it seems a similar problem
which StandbyAcquireAccessExclusiveLock() tries to avoid.

...Is this the problem you call "general problem" above ?


regards,


-- Hiroyuki YAMADA Kokolink Corporation yamada@kokolink.net


pgsql-hackers by date:

Previous
From: Cédric Villemain
Date:
Subject: Re: Buffer statistics for pg_stat_statements
Next
From: Peter Eisentraut
Date:
Subject: Re: PATCH: Add hstore_to_json()