Re: Speed differences between two servers
Vincent Veyron <vv.lists@wanadoo.fr>
From: Vincent Veyron <vv.lists@wanadoo.fr>
To: "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Date: 2017-05-10T08:27:46Z
Lists: pgsql-performance
On Tue, 9 May 2017 10:24:20 -0600 Scott Marlowe <scott.marlowe@gmail.com> 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 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. > Sure, but I'm getting plenty of performance already : my little machines can serve 40 requests/second with 6 or 7 queries per request. So I'm fine for a while. You can see for yourself if you enter the demo account for the site in my sig, and click in a couple of files (it's the database that gets re-created by the procedure I mentionned in my original post) -- Bien à vous, Vincent Veyron https://legalcase.libremen.com/ Legal case, contract and insurance claim management software