On Tue, 9 May 2017 10:24:20 -0600
Scott Marlowe wrote:
>
> 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
On Tue, May 9, 2017 at 7:08 AM, Vincent Veyron 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 se
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 th
On Mon, 8 May 2017 17:35:38 -0600
Scott Marlowe wrote:
> Without seeing what your test sql file does I have no idea what the
> big difference in the other direction.
It truncates 59 tables, copies data back from a set of text files, inserts a
few single records and does a few select setval('')
On Mon, May 8, 2017 at 5:06 PM, Scott Marlowe wrote:
> On Mon, May 8, 2017 at 4:24 PM, Vincent Veyron wrote:
>> On Mon, 8 May 2017 12:48:29 -0600
>> Scott Marlowe wrote:
>>> > -Why are regular queries much faster on this same server?
>>>
>>> That's a whole nother subject. Most likely the faster
On Mon, May 8, 2017 at 4:24 PM, Vincent Veyron wrote:
> On Mon, 8 May 2017 12:48:29 -0600
> Scott Marlowe wrote:
>
> Hi Scott,
>
> Thank you for your input.
>
>>
>> The most likely cause of the difference would be that one server IS
>> honoring fsync requests from the db and the other one isn't.
On Mon, 8 May 2017 12:48:29 -0600
Scott Marlowe wrote:
Hi Scott,
Thank you for your input.
>
> The most likely cause of the difference would be that one server IS
> honoring fsync requests from the db and the other one isn't.
>
> If you run pgbench on both (something simple like pgbench -c 1
On Mon, May 8, 2017 at 11:49 AM, Vincent Veyron wrote:
> Hello,
>
> I use two dedicated bare metal servers (Online and Kimsufi). The first one
> takes much longer to execute a procedure that recreates a database by
> truncating its tables, then copying the data from a set of text files; it is
>
Hello,
I use two dedicated bare metal servers (Online and Kimsufi). The first one
takes much longer to execute a procedure that recreates a database by
truncating its tables, then copying the data from a set of text files; it is
however much faster for more typical SELECT and INSERT queries don
