With LIMIT 1, I get 3 shared buffers hit, pretty much always.
Check if assessoria_pkey index is bloated.
Regards,
Igor Neyman
you repeat it with "LIMIT 1"?
Notice huge difference in "buffers hit" while doing (the same) Index Scan in
two plans.
Regards,
Igor Neyman
umber of allowed
connections in PG config to about 50, while allowing thousands client
connection when configuring PgBouncer.
Regards,
Igor Neyman
solves the problem only temporarily.
Question is how can we debug what is going on?
Best Regards,
Krzysztof PĆocharz
___
Why do you have to run Analyze? Did you turn off Autovacuum?
Regards,
Igor Neyman
to lock the table, they
could just prevent from cleaning "old" row versions.
Regards,
Igor Neyman
diff size except the host ( same
OS and PG version 9.5.3)?
Thank you
Table is still bloated because of some long running transactions, which don't
allow full vacuum to do its job?
Regards,
Igor
From: Henrik Cednert (Filmlance) [mailto:henrik.cedn...@filmlance.se]
Sent: Tuesday, November 21, 2017 11:48 AM
To: pgsql-performance@lists.postgresql.org
Subject: Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade
I VACUUM every sunday so that is done already. =/
Not sure I have the proper