| 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 23:16:09 |
| Message-ID: | CAMkU=1wiLracrhxCuKL_MgoH1VUeD12pu0++-E63QweWqof7jg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Sun, Mar 11, 2018 at 10:33 AM, dangal <danielito(dot)gallo(at)gmail(dot)com> wrote:
> jeff thank you very much for your time, I tell you, they are the same
> queries
> with the same parameters, I take 3 minutes for example, but I execute it
> and
> it takes me seconds, that's why I suspect it is the shared buffer
> The server had 16 GB and we increased it to 24, but I really do not know if
> it should continue to increase since they are not our own resources, we
> have
> to ask for them and justify them
>
If that is the only query that you have trouble with, it might be easiest
just to set up a cron job to run it periodically just to keep that data set
in cache. Not very elegant, but it can be effective.
Cheers,
Jeff
| From | Date | Subject | |
|---|---|---|---|
| Next Message | dangal | 2018-03-12 01:43:06 | Re: Memory size |
| Previous Message | Andreas Joseph Krogh | 2018-03-11 21:45:50 | Sv: Re: Sv: Memory size |