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
På søndag 11. mars 2018 kl. 14:57:52, skrev dangal mailto:danielito.ga...@gmail.com>>:
The rest of the memory Andreas, 16 gb
Then I'd blame it on the virtual environment. It's common at least in the
VMWare-world to have a 8GB disk-cache and reads going beond that are slow.
You've not told us an
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
The rest of the memory Andreas, 16 gb
--
Sent from:
http://www.postgresql-archive.org/PostgreSQL-performance-f2050081.html
På søndag 11. mars 2018 kl. 13:48:41, skrev dangal mailto:danielito.ga...@gmail.com>>:
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 ru
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
10 matches
Mail list logo
