[EXTERNAL] Re: FreeBSD10 Stable + ZFS + PostgreSQL + SSD performance drop < 24 hours

[Eduardo Morras]

On Mon, 12 Jun 2017 04:50:44 +0000
"Caza, Aaron" <Aaron.Caza at ca.weatherford.com> wrote:

> Thanks, Jov, for you suggestions.  Per your e-mail I added ?explain
> analyze? to the script:

Can you check that autovacuum is not involved in a lock storm?
Autovacuums workers start to work but a higher level lock is acquired
by other process/transaction stopping autovacuum workers continuously,
making autovacuum useless (but trying continually to clean). 

Also, you're comparing Postgresql 9.1 with 9.5, are you using the same
conf file? Did you upgrade it (conf file) to 9.5?

---   ---
Eduardo Morras <emorrasg at yahoo.es>