Re: [PERFORM] Sudden Query slowdown on our Postgresql Server

2012-03-23 Thread Sebastian Melchior
n On 23.03.2012, at 08:10, Yeb Havinga wrote: > On 2012-03-23 05:53, Sebastian Melchior wrote: >> Hi, >> >> we already used iostat and iotop during times of the slowdown, there is no >> sudden drop in I/O workload in the times of the slowdown. Also the iowait >> does

Re: [PERFORM] Sudden Query slowdown on our Postgresql Server

2012-03-22 Thread Sebastian Melchior
room" left. Sebastian On 23.03.2012, at 05:48, Scott Marlowe wrote: > I'd suggest the handy troubleshooting tools sar, iostat, vmstat and iotop > > On Thu, Mar 22, 2012 at 10:37 PM, Sebastian Melchior > wrote: >> Hi, >> >> yeah we log those, those ti

Re: [PERFORM] Sudden Query slowdown on our Postgresql Server

2012-03-22 Thread Sebastian Melchior
Hi, yeah we log those, those times do not match the times of the slowdown at all. Seems to be unrelated. Sebastian On 23.03.2012, at 01:47, Stephen Frost wrote: > * Sebastian Melchior (webmas...@mailz.de) wrote: >> Does anyone have any idea what could cause this issue or how we ca

[PERFORM] Sudden Query slowdown on our Postgresql Server

2012-03-22 Thread Sebastian Melchior
Hi, we are currently seeing some strange performance issues related to our Postgresql Database. Our Setup currently contains: - 1 Master with 32GB Ram and 6 x 100GB SSDs in RAID10 and 2 Quad Core Intel Processors (this one has a failover Box, the data volume is shared via DRBD) - 2 Slaves with 1