>> On Tue, Dec 17, 2019 at 08:03:41PM +, Piotr Włodarczyk wrote:
>> Currently we're working on PSQL 11.5 and we're trying upgrade to 12.1.
>>
>> During that we have a problem:
>>
>> command: "/usr/pgsql-12/bin/pg_dump" --host /cluster/postgresql --port
50432
>> --username postgres --schema-on
On Tue, Dec 17, 2019 at 08:03:41PM +, Piotr Włodarczyk wrote:
> Currently we're working on PSQL 11.5 and we're trying upgrade to 12.1.
>
> During that we have a problem:
>
> command: "/usr/pgsql-12/bin/pg_dump" --host /cluster/postgresql --port 50432
> --username postgres --schema-only --quot
Hello,
Currently we're working on PSQL 11.5 and we're trying upgrade to 12.1.
During that we have a problem:
command: "/usr/pgsql-12/bin/pg_dump" --host /cluster/postgresql --port 50432
--username postgres --schema-only --quote-all-identifiers --binary-upgrade
--format=custom --file="pg_upgrade
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
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
14 matches
Mail list logo
