Date: Tue, 13 Jun 2017 20:36:15 +0200 From: Eduardo Morras <emorrasg@yahoo.es> To: freebsd-hackers@freebsd.org Subject: Re: [EXTERNAL] Re: FreeBSD10 Stable + ZFS + PostgreSQL + SSD performance drop < 24 hours Message-ID: <20170613203615.ae6df0a1c94bffe1dc6745fc@yahoo.es> In-Reply-To: <4410c303314a4d11832a8d248e0b53e1@DM2PR58MB013.032d.mgd.msft.net> References: <a8523e8099404bd699525f8ff7763819@DM2PR58MB013.032d.mgd.msft.net> <CADyrUxNeRW_fKJzoc9zoZi3J-6L%2BtXnJuW3q_4cremUy7sP7fA@mail.gmail.com> <4410c303314a4d11832a8d248e0b53e1@DM2PR58MB013.032d.mgd.msft.net>
next in thread | previous in thread | raw e-mail | index | archive | help
On Mon, 12 Jun 2017 04:50:44 +0000 "Caza, Aaron" <Aaron.Caza@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).=20 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@yahoo.es>
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20170613203615.ae6df0a1c94bffe1dc6745fc>