Re: [PERFORM] RES: Priority to a mission critical transaction

2006-11-29 Thread Ron Mayer
Brian Hurt wrote: > Ron Mayer wrote: >> Brian Hurt wrote: >>> Mark Lewis wrote: On Wed, 2006-11-29 at 08:25 -0500, Brian Hurt wrote: > But, especially given priority inheritance, is there any > > That second paper is interesting in that it says that STM solves the > priority inversi

Re: [PERFORM] RES: Priority to a mission critical transaction

2006-11-29 Thread Brian Hurt
Ron Mayer wrote: Brian Hurt wrote: Mark Lewis wrote: On Wed, 2006-11-29 at 08:25 -0500, Brian Hurt wrote: I have the same question. I've done some embedded real-time programming, so my innate reaction to priority inversions is that they're evil. But, especially given prior

Re: [PERFORM] RES: Priority to a mission critical transaction

2006-11-29 Thread Ron Mayer
Brian Hurt wrote: > Mark Lewis wrote: >> On Wed, 2006-11-29 at 08:25 -0500, Brian Hurt wrote: >> >>> I have the same question. I've done some embedded real-time >>> programming, so my innate reaction to priority inversions is that >>> they're evil. But, especially given priority inheritance,

Re: [PERFORM] RES: Priority to a mission critical transaction

2006-11-29 Thread Brian Hurt
Mark Lewis wrote: On Wed, 2006-11-29 at 08:25 -0500, Brian Hurt wrote: ... I have the same question. I've done some embedded real-time programming, so my innate reaction to priority inversions is that they're evil. But, especially given priority inheritance, is there any situation where

Re: [PERFORM] RES: Priority to a mission critical transaction

2006-11-29 Thread Mark Lewis
On Wed, 2006-11-29 at 08:25 -0500, Brian Hurt wrote: ... > I have the same question. I've done some embedded real-time > programming, so my innate reaction to priority inversions is that > they're evil. But, especially given priority inheritance, is there any > situation where priority inversi

Re: [PERFORM] RES: Priority to a mission critical transaction

2006-11-29 Thread Brian Hurt
Ron Mayer wrote: Before asking them to remove it, are we sure priority inversion is really a problem? I thought this paper: http://www.cs.cmu.edu/~bianca/icde04.pdf did a pretty good job at studying priority inversion on RDBMs's including PostgreSQL on various workloads (TCP-W and TCP-C) and fo

Re: [PERFORM] RES: Priority to a mission critical transaction

2006-11-29 Thread Ron Mayer
Mark Kirkwood wrote: > Ron Mayer wrote: >> Short summary: >> * Papers studying priority inversion issues with >> databases including PosgreSQL and realistic workloads >> conclude setpriority() helps even in the presence of >> priority inversion issues for TCP-C and TCP-W like >> w

Re: [PERFORM] RES: Priority to a mission critical transaction

2006-11-28 Thread Mark Kirkwood
Ron Mayer wrote: Short summary: * Papers studying priority inversion issues with databases including PosgreSQL and realistic workloads conclude setpriority() helps even in the presence of priority inversion issues for TCP-C and TCP-W like workloads. * Avoiding priority inversi

Re: [PERFORM] RES: Priority to a mission critical transaction

2006-11-28 Thread Ron Mayer
Before asking them to remove it, are we sure priority inversion is really a problem? I thought this paper: http://www.cs.cmu.edu/~bianca/icde04.pdf did a pretty good job at studying priority inversion on RDBMs's including PostgreSQL on various workloads (TCP-W and TCP-C) and found that the benefit

Re: [PERFORM] RES: Priority to a mission critical transaction

2006-11-28 Thread Ron Mayer
Short summary: * Papers studying priority inversion issues with databases including PosgreSQL and realistic workloads conclude setpriority() helps even in the presence of priority inversion issues for TCP-C and TCP-W like workloads. * Avoiding priority inversion with priority in