Re: [PERFORM] Lock pileup causes server to stall

2014-11-12 Thread Jesper Krogh
>>> >>> Current FK checking makes you wait if the referenced tuple is modified >>> on any indexed column, not just those that are actually used in >>> foreign keys. Maybe this case would be sped up if we optimized that. >> >> Even if it is an gin index that is being modified? seems like

Re: [PERFORM] Lock pileup causes server to stall

2014-11-12 Thread Josh Berkus
On 11/12/2014 05:51 AM, Alvaro Herrera wrote: > Anyway, the fklocks patch was stupidly complex (and still got much stuff > wrong). I didn't want to add more ground to objections by additionally > breaking the abstraction between heapam and the concept of "columns > referenced by a foreign key cons

Re: [PERFORM] Lock pileup causes server to stall

2014-11-12 Thread Alvaro Herrera
Jesper Krogh wrote: > > > On 10/11/2014, at 22.40, Alvaro Herrera wrote: > > > > Josh Berkus wrote: > >> All, > >> > >> pg version: 9.3.5 > >> RHEL 6.5 > >> 128GB/32 cores > >> Configured with shared_buffers=16GB > >> Java/Tomcat/JDBC application > >> > >> Server has an issue that whenever we

Re: [PERFORM] Lock pileup causes server to stall

2014-11-11 Thread Jesper Krogh
> On 10/11/2014, at 22.40, Alvaro Herrera wrote: > > Josh Berkus wrote: >> All, >> >> pg version: 9.3.5 >> RHEL 6.5 >> 128GB/32 cores >> Configured with shared_buffers=16GB >> Java/Tomcat/JDBC application >> >> Server has an issue that whenever we get lock waits (transaction lock >> waits, usu

Re: [PERFORM] Lock pileup causes server to stall

2014-11-11 Thread Jeff Janes
On Tue, Nov 11, 2014 at 9:11 AM, Josh Berkus wrote: > On 11/10/2014 01:40 PM, Alvaro Herrera wrote: > > Josh Berkus wrote: > >> All, > >> > >> pg version: 9.3.5 > >> RHEL 6.5 > >> 128GB/32 cores > >> Configured with shared_buffers=16GB > >> Java/Tomcat/JDBC application > >> > >> Server has an iss

Re: [PERFORM] Lock pileup causes server to stall

2014-11-11 Thread Josh Berkus
On 11/10/2014 01:40 PM, Alvaro Herrera wrote: > Josh Berkus wrote: >> All, >> >> pg version: 9.3.5 >> RHEL 6.5 >> 128GB/32 cores >> Configured with shared_buffers=16GB >> Java/Tomcat/JDBC application >> >> Server has an issue that whenever we get lock waits (transaction lock >> waits, usually on an

Re: [PERFORM] Lock pileup causes server to stall

2014-11-10 Thread Alvaro Herrera
Josh Berkus wrote: > All, > > pg version: 9.3.5 > RHEL 6.5 > 128GB/32 cores > Configured with shared_buffers=16GB > Java/Tomcat/JDBC application > > Server has an issue that whenever we get lock waits (transaction lock > waits, usually on an FK dependancy) lasting over a minute or more than > 10

[PERFORM] Lock pileup causes server to stall

2014-11-10 Thread Josh Berkus
All, pg version: 9.3.5 RHEL 6.5 128GB/32 cores Configured with shared_buffers=16GB Java/Tomcat/JDBC application Server has an issue that whenever we get lock waits (transaction lock waits, usually on an FK dependancy) lasting over a minute or more than 10 at once, *all* queries on the server slow