| From: | Vick Khera <vivek(at)khera(dot)org> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Total ram size study |
| Date: | 2017-04-22 16:20:12 |
| Message-ID: | CALd+dce51U5U0FcnPZtjXTVQhjbTpdD+VGcYY-J1oNqBJv_BTQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I've not done a formal study, but I've always found that throwing hardware
at the problem does wonders. My current database I made faster by bumping
RAM until the entire working set fits in memory. The server has 256GB of
RAM, half of which is used by ZFS for its purposes, and the other half for
Postgres. The prior iteration of the servers only had 64GB of RAM and the
difference was very remarkable.
On Sat, Apr 22, 2017 at 11:27 AM, Melvin Davidson <melvin6925(at)gmail(dot)com>
wrote:
>
>
>
> *Has anyone ever done a study on performance increase via ram increase?I
> have a client on AWS with 8GB total ram (2GB shared_buffers), and I
> amcurious if doubling the ram to 16GB (4GB shared_buffers) will result in
> minimizing query response time.*
>
> --
> *Melvin Davidson*
> I reserve the right to fantasize. Whether or not you
> wish to share my fantasy is entirely up to you.
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Melvin Davidson | 2017-04-22 16:30:23 | Re: Total ram size study |
| Previous Message | Melvin Davidson | 2017-04-22 15:27:19 | Total ram size study |