| From: | "Graeme B(dot) Bell" <grb(at)skogoglandskap(dot)no> |
|---|---|
| To: | "ktm(at)rice(dot)edu" <ktm(at)rice(dot)edu> |
| Cc: | Nico Sabbi <nicola(dot)sabbi(at)poste(dot)it>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Configuration tips for very large database |
| Date: | 2015-02-13 14:09:32 |
| Message-ID: | 723EE05F-2FCC-4E7E-8ED2-FB563A8F8EDC@skogoglandskap.no |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
>>
>
> Hi Nico,
>
> No one has mentioned the elephant in the room, but a database can
> be very I/O intensive and you may not be getting the performance
> you need from your virtual disk running on your VMware disk subsystem.
> What do IOmeter or other disk performance evaluation software report?
>
> Regards,
> Ken
Anecdatum:
Moving from a contended VMware hard-disk based filesystem running over the network, to a bare metal RAID10 SSD, resulted in many DB operations running 20-30x faster.
Table sizes circa 10-20G, millions of rows.
Graeme.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sven R. Kunze | 2015-02-14 18:13:10 | Reverse Key Index |
| Previous Message | ktm@rice.edu | 2015-02-13 14:01:15 | Re: Configuration tips for very large database |