| From: | Vincent Veyron <vv(dot)lists(at)wanadoo(dot)fr> |
|---|---|
| To: | "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Speed differences between two servers |
| Date: | 2017-05-10 08:27:46 |
| Message-ID: | 20170510102746.131c564150176927bfd78726@wanadoo.fr |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Tue, 9 May 2017 10:24:20 -0600
Scott Marlowe <scott(dot)marlowe(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | plukovic | 2017-05-11 13:54:02 | Speed differences between in executing the same query |
| Previous Message | Scott Marlowe | 2017-05-09 16:24:20 | Re: Speed differences between two servers |