| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Sachin Srivastava <ssr(dot)teleatlas(at)gmail(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: RAM of Postgres Server |
| Date: | 2016-01-07 05:55:10 |
| Message-ID: | CAKFQuwbV70BjjKxLM7GmJE2BL6FP9WxbrooFJjvTft4bMktxZg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Jan 6, 2016 at 10:39 PM, Sachin Srivastava <ssr(dot)teleatlas(at)gmail(dot)com>
wrote:
> Dear Team,
>
> Please suggest, how much RAM and core should be define for New Postgres
> database server, if we will use Postgres 9.3 and above.
>
> If suppose my postgres database size will be near about 300 to 500 GB for
> future.
>
> There is any document regarding this server configuration, suggest ?
>
>
>
Total size is meaningless because, for instance, consider if of that
500GB, 499GB of it
is archive data that is rarely if ever accessed.
RAM holds data that is recently accessed - how much of that will you have?
Cores help service concurrent requests - how many of those will you have?
How fast will they complete?
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sachin Srivastava | 2016-01-07 07:32:00 | Re: RAM of Postgres Server |
| Previous Message | Gavin Flower | 2016-01-07 05:47:21 | Re: RAM of Postgres Server |