Skip site navigation (1) Skip section navigation (2)

Re: PHP and PostgreSQL

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: PHP and PostgreSQL
Date: 2001-01-02 04:59:56
Message-ID: 11150.978411596@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-interfaces
"Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> writes:
> Now what happens is if someone browses the phorums for a little while, and
> then switches to pages that use our own db classes, you get random slowdowns
> (ie. a select occurs, and then times out after 2 mins or so).
> If you use psql, and perform the select you get a 'shared memory corruption'
> and 'timed out waiting for lock' errors.

Ugh.  We would like to think that client misbehavior couldn't cause such
things.  Can you dig into this some more, and provide further details on
what is happening and what the sequence of client requests is?

			regards, tom lane

In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2001-01-02 05:16:12
Subject: Re: Current Sources/UW7.1.1
Previous:From: Patrick DunfordDate: 2001-01-02 04:14:02
Subject: Ignored PostgreSQL SET command

pgsql-interfaces by date

Next:From: Bruce MomjianDate: 2001-01-02 07:16:53
Subject: Re: [INTERFACES] Re: PHP and PostgreSQL
Previous:From: Rod TaylorDate: 2001-01-02 04:08:16
Subject: Re: PHP and PostgreSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group