Re: Sudden Query slowdown on our Postgresql Server - Mailing list pgsql-performance

From Yeb Havinga
Subject Re: Sudden Query slowdown on our Postgresql Server
Date
Msg-id 4F6C21ED.903@gmail.com
Whole thread Raw
In response to Re: Sudden Query slowdown on our Postgresql Server  (Sebastian Melchior <webmaster@mailz.de>)
Responses Re: Sudden Query slowdown on our Postgresql Server
List pgsql-performance
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
ofthe slowdown. Also the iowait does not spike and stays as before. 
> So i do not think that this is I/O related. As the disks are SSDs there also still is some "head room" left.

I've seen a ssd completely lock up for a dozen seconds or so after
giving it a smartctl command to trim a section of the disk. I'm not sure
if that was the vertex 2 pro disk I was testing or the intel 710, but
enough reason for us to not mount filesystems with -o discard.

regards,
Yeb




pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Sudden Query slowdown on our Postgresql Server
Next
From: Sebastian Melchior
Date:
Subject: Re: Sudden Query slowdown on our Postgresql Server