| From: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
|---|---|
| To: | dangal <danielito(dot)gallo(at)gmail(dot)com> |
| Cc: | "pgsql-performa(dot)" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Memory size |
| Date: | 2018-03-11 16:59:09 |
| Message-ID: | CAMkU=1xu3YhU=7Pit-2xM3EMP+n0A+o6A2s-QNRy0C4spgSbXA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Sun, Mar 11, 2018 at 5:48 AM, dangal <danielito(dot)gallo(at)gmail(dot)com> wrote:
>
> Dear some consultation, I have a base of about 750 GB in size and we are
> having problem of slowness in certain views of the application, so I have
> been seeing it is apparently a memory problem because if I run again the
> view runs fast, the base is in a virtual server with 24 GB of RAM and 8 GB
> of shared buffer, with this information how much would you recommend to put
> a memory in the server
>
There is no way to answer that with the information you provide.
Are the "certain views" run with different supplied parameters on different
executions, or are they run with no parameters or unchanging ones?
How long can you wait between the first run and the second run before the
second run is no longer fast?
Cheers,
Jeff
| From | Date | Subject | |
|---|---|---|---|
| Next Message | dangal | 2018-03-11 17:33:42 | Re: Memory size |
| Previous Message | dangal | 2018-03-11 13:57:52 | Re: Sv: Memory size |