I was seeing thanks to your recommendations and I found the following, to
see what you think
cache hit rate 0.99637443599712620769
We have the default values 5 minutes
total checkpoint minutes beetween checkpoint
26927 0.358545045634493
temp_files temp_si
With several views, Jeff is following us
Tomorrow I will see if I can provide more data to see if you can guide me a
bit
Thank you so much everyone
--
Sent from:
http://www.postgresql-archive.org/PostgreSQL-performance-f2050081.html
On Sun, Mar 11, 2018 at 10:33 AM, dangal 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 1
thank you very much Tomas, tomorrow at work I will see to capture plans of
ejcucion to see if you can give me a hand, I am really helping me a lot with
their advice
--
Sent from:
http://www.postgresql-archive.org/PostgreSQL-performance-f2050081.html
On 03/11/2018 06:33 PM, dangal 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 incr
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
On Sun, Mar 11, 2018 at 5:48 AM, dangal 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