From owner-freebsd-hackers@freebsd.org Tue Jun 13 18:36:52 2017 Return-Path: Delivered-To: freebsd-hackers@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id 2B2FBBFB89D for ; Tue, 13 Jun 2017 18:36:52 +0000 (UTC) (envelope-from emorrasg@yahoo.es) Received: from nm36-vm6.bullet.mail.ir2.yahoo.com (nm36-vm6.bullet.mail.ir2.yahoo.com [212.82.97.138]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id 9C8B62200 for ; Tue, 13 Jun 2017 18:36:51 +0000 (UTC) (envelope-from emorrasg@yahoo.es) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.es; s=s2048; t=1497378810; bh=MyEif2JyOucv24Uel358K1ZYRvEnFn4un6nrXgQaTKI=; h=Date:From:To:Subject:In-Reply-To:References:From:Subject; b=EJokprq9ANV30eLdaXg/iACohdPnVR6QrN+UBkaDrrS0Poh/BXO99/qispCigJfHvly6n/d4oa7+buFZ7wuReylVzY9HXvK+WO/iCNW2galmrXFC8ADYb04pU+mmbNb73/apv0zFI4RCbUHNQEzGiFwhNRoYYHzaT+vAsQNPvXDyUsmH5aBXT65sh50f5G9VArTcbXN3FN/fBLJWL/68UfnZGKyO0XJoVutT41Rz0O9Ax93VfoCGXgNF3/iPcyW5zJajh/HIdPnDPXWMDHGq+MycmWK0B0c+9X/nHsjuw0GyN7O9rqTc6SeIz6YMmNA15OLxJnW231xIFaGvESPmpg== Received: from [212.82.98.57] by nm36.bullet.mail.ir2.yahoo.com with NNFMP; 13 Jun 2017 18:33:30 -0000 Received: from [46.228.39.91] by tm10.bullet.mail.ir2.yahoo.com with NNFMP; 13 Jun 2017 18:33:30 -0000 Received: from [127.0.0.1] by smtp128.mail.ir2.yahoo.com with NNFMP; 13 Jun 2017 18:33:30 -0000 X-Yahoo-Newman-Id: 600039.53384.bm@smtp128.mail.ir2.yahoo.com X-Yahoo-Newman-Property: ymail-3 X-YMail-OSG: 23DDvNwVM1m9wiq.yajxkov15nX1XvHYSjHR77Bk8HIP2fC N4dvq7S8EzRcdAl1xvwO.JgR7RxQXm.Bk9JywIgRxkkWSelSMxE47v2rfcW. Yv8itzZjpHU3zNUWc2ckS8U.35thXEzDu4ueupoLRIP0Gp5tf4_MCJ3beUKe Fx5Xp9yPxN8xP0..7GPL1nCrOt91dv57egU5lg1Hihx...CLbxEPALilKIsc 1hCPAV2aaAXZFVQSKKaUcBWXdTvS9WAcA_RRfIZ93ceksIUiE9OYpVXFr193 YyMBn9alTKtzyub8NaZpr_rQxlyIuCGIoHU5Vzl_kb1V.iJMVsOWqoqTPVt8 2E_V1KAeGA3fdAE7ADytsyz203O7NAvDJ27MxXSEdM0aM5vWxFJ.KQ1q8siU tJJRgtBMwPLYrbEihOa0tXu44dJaYhhFz7APtoiDOyzktcNyGwNTrskTHJoA So48W1xIHeYlYAPcwNEweHBWxFszrwlHnqJozRMSk4GWvEpNWyT7vPCTGaaF mKSlyIt8eu7w_vd9NNEWsGLDclYQoDY9V1xMrOmEjnEUrfVVMFXIKFhYRyJ3 MnM8B X-Yahoo-SMTP: mX392iiswBAeJNdO_s.EW62LZDJR Date: Tue, 13 Jun 2017 20:36:15 +0200 From: Eduardo Morras 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: <4410c303314a4d11832a8d248e0b53e1@DM2PR58MB013.032d.mgd.msft.net> X-Mailer: Sylpheed 3.5.1 (GTK+ 2.24.29; amd64-portbld-freebsd11.0) Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-BeenThere: freebsd-hackers@freebsd.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: Technical Discussions relating to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 13 Jun 2017 18:36:52 -0000 On Mon, 12 Jun 2017 04:50:44 +0000 "Caza, Aaron" 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