Re: [HACKERS] Reducing likelihood of deadlocks (was referential Integrity and SHARE locks)

2007-02-14 Thread Alex Hayward
On Tue, 13 Feb 2007, Marc Munro wrote: > On Mon, 2007-12-02 at 00:10 -0500, Tom Lane wrote: > > Marc Munro <[EMAIL PROTECTED]> writes: > > > Consider a table C containing 2 child records C1 and C2, of parent P. > > > If transaction T1 updates C1 and C2, the locking order of the the > > > records w

Re: [HACKERS] strange performance anomalies

2002-08-10 Thread Alex Hayward
On 9 Aug 2002, Scott Shattuck wrote: > Hi, > > We recently put up a new 7.2.1 installation on Solaris 8 that serves a > 24x7 e-commerce site. The system seems to run pretty well most of the > time but we see a consistent form of performance anomaly. > > Watching pg_stat_activity the system spen

Re: [HACKERS] RI triggers and schemas

2002-03-27 Thread Alex Hayward
On Tue, 26 Mar 2002, Stephan Szabo wrote: > > On Tue, 26 Mar 2002, Jan Wieck wrote: > > > Tom Lane wrote: > > > I think the existing scheme of generating the plan during first use > > > in a particular backend is fine. At least as long as we're sticking > > > with standard plans at all ... IIRC

Re: [HACKERS] initdb dies during IpcSemaphoreCreate under BSD jail

2002-03-27 Thread Alex Hayward
On Wed, 27 Mar 2002, Tom Lane wrote: > "Joel Burton" <[EMAIL PROTECTED]> writes: > >> This will allow you to run a single postgres in a single jail only one > >> user would have access to it. If you try to run more then one it will > >> try to use the same shared memory and crash. > > > Is this,