Re: [HACKERS] PS display and standby query conflict

2010-12-17 Thread Robert Haas
On Sun, Dec 12, 2010 at 10:06 PM, Fujii Masao wrote: >> But if it annoys you, it seems OK to change it. Don't see a reason to >> backpatch though? > > I think that It's worth backpatch to prevent users who observe the > occurrence of the query conflicts carefully for testing 9.0 from > getting co

Re: [HACKERS] PS display and standby query conflict

2010-12-12 Thread Fujii Masao
On Sat, Dec 11, 2010 at 11:28 PM, Simon Riggs wrote: >> This problem happens because ResolveRecoveryConflictWithVirtualXIDs >> resets PS display for each read-only transactions that recovery >> waits for. Why do we need to reset that each time even though >> the conflict has not been resolved yet?

Re: [HACKERS] PS display and standby query conflict

2010-12-11 Thread Simon Riggs
On Thu, 2010-12-09 at 22:13 +0900, Fujii Masao wrote: > When I created the conflict between recovery and many read-only > transactions in the standby server for test purpose, I found that the > keyword "waiting" disappeared from PS display for just a moment > even though the conflict had not been

[HACKERS] PS display and standby query conflict

2010-12-09 Thread Fujii Masao
Hi, When I created the conflict between recovery and many read-only transactions in the standby server for test purpose, I found that the keyword "waiting" disappeared from PS display for just a moment even though the conflict had not been resolved yet. This seems strange to me. This problem happ