Re: Speed differences between two servers

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Vincent Veyron <vv(dot)lists(at)wanadoo(dot)fr>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Speed differences between two servers
Date: 2017-05-09 16:24:20
Message-ID: CAOR=d=1Rk2qtW+YQLQZd2cZTR9rG0cAVHpaOjXNE1Q1a9LGH1Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, May 9, 2017 at 7:08 AM, Vincent Veyron <vv(dot)lists(at)wanadoo(dot)fr> wrote:
>
> Well, the response to the ticket was quite fast :
>
> https://status.online.net/index.php?do=details&task_id=720
>
> Here's the stated cause :
>
>>Our tests have confirmed an issue caused by the fans of the power supplies installed in several chassis.
>
>>The fans create vibrations amplifying errors on the discs.
>
> Now on to decide whether I'm waiting for the fix or re-building a new box...
>
> Thanks a bunch for your help.

You're welcome, any time.

As for the hard drives, can you upgrade to a pair of SSDs? If your
data set fits on (and will continue to fit on) SSDs, the performance
gained from SSDs is HUGE and worth a few hundred extra for the drive.
Note that you want to use the Intel enterprise stuff that survives
power loss, not the cheap low end SSDs. May be an easy fix for your
hosting company and a big performance gain.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Vincent Veyron 2017-05-10 08:27:46 Re: Speed differences between two servers
Previous Message Vincent Veyron 2017-05-09 13:08:52 Re: Speed differences between two servers