From owner-freebsd-stable@freebsd.org Thu Oct 20 22:07:28 2016 Return-Path: Delivered-To: freebsd-stable@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 F2203C1B240 for ; Thu, 20 Oct 2016 22:07:28 +0000 (UTC) (envelope-from bsdunix44@gmail.com) Received: from mail-qt0-x235.google.com (mail-qt0-x235.google.com [IPv6:2607:f8b0:400d:c0d::235]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client CN "smtp.gmail.com", Issuer "Google Internet Authority G2" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id BB5B2DA3 for ; Thu, 20 Oct 2016 22:07:28 +0000 (UTC) (envelope-from bsdunix44@gmail.com) Received: by mail-qt0-x235.google.com with SMTP id s49so70417774qta.0 for ; Thu, 20 Oct 2016 15:07:28 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=references:in-reply-to:mime-version:content-transfer-encoding :message-id:cc:from:subject:date:to; bh=L/TJ/B5UGoyeOf8TgSW9PjyPSgVBDU5Z3YdKQQ1NIU4=; b=fQyoUDXHmmhM9E0jBDyGWxhHDTIS/7wBYkd55wQ7SmGTuAZh0n9yIP5RqaBsfazZKY B4XL4YGp4fydQts1M1FRz/6fT8A4lPELWfvQDr0wsia7llbWSnlLaEJlhPzKoJPcoAls WpVbN4ESQPKApmpUWG9JJ+bUNHl8Wqb04M10vmAWAulPx3D4RzwLmBSM1psE62toxVM0 gdJ+IBfG9CCWUKsXFHz4BCLKZUnfdILihvH0/VXokD2HFre/26nnPwRWBtXg4dpL+qQZ +ND3vnXSvase4SSrWii85cKTyD9nlQxB6Ij3coy9UhNPfpMbGPsSm2w3tHRrXG5KCCWL +nZw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:references:in-reply-to:mime-version :content-transfer-encoding:message-id:cc:from:subject:date:to; bh=L/TJ/B5UGoyeOf8TgSW9PjyPSgVBDU5Z3YdKQQ1NIU4=; b=Pdv7ISO4uj4dZndkipOux0qeOVRivcdY20r4W/t6nSiCMdvp0tHFXLvQSQnmR4HPec OIeUfoKqj65deevSRnYuWg2HVyZvofmgtF/soXl3b9TSaOmU9ZXLmsvhxPS0oqkSO1Uv iPAjNeW0C7avqryn/P9NrAG2j+FR786Uco1UuymGlAJs4epJjL3PIn9+z090u0Nka8fA i+aEm4cf1AqeR/ApCiENYymbvDChYmNsNfGaKrTMKscLZzYJQ9fE6Uy/rATY7pVdj5mY q3CAJZOqqDks7PXn+9Lgv900H19Ms/Ubw1C9WXhHdj/4QtExV4fz5+HbPmug6Cg09Job DsSg== X-Gm-Message-State: ABUngvcCAPbacTntCZcZ2kFE/958lv6pHSVVoIXkwlGpO2M6jLKDe5RP7FZschnEEHr6qQ== X-Received: by 10.200.57.58 with SMTP id s55mr2844362qtb.68.1477001247793; Thu, 20 Oct 2016 15:07:27 -0700 (PDT) Received: from [30.83.188.127] ([172.56.2.145]) by smtp.gmail.com with ESMTPSA id q190sm24711959qke.31.2016.10.20.15.07.26 (version=TLS1 cipher=ECDHE-RSA-AES128-SHA bits=128/128); Thu, 20 Oct 2016 15:07:26 -0700 (PDT) References: <4d9269af-ed64-bb73-eb7f-98a3f5ffd5a2@norma.perm.ru> In-Reply-To: Mime-Version: 1.0 (1.0) Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Message-Id: Cc: Peter , freebsd-stable@freebsd.org X-Mailer: iPhone Mail (14A456) From: Chris Watson Subject: Re: zfs, a directory that used to hold lot of files and listing pause Date: Thu, 20 Oct 2016 17:07:23 -0500 To: Jonathan Chen X-BeenThere: freebsd-stable@freebsd.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: Production branch of FreeBSD source code List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 20 Oct 2016 22:07:29 -0000 While I have yet to encounter this with PG on ZFS, knock on wood, this obvio= usly is not an isolated issue and if possible those experiencing it should d= o as much investigation as possible and open a PR. This seems like something= I'm going to read about FreeBSD and PG/ZFS over at Hacker News from a Linux= switcher as they explain why they went back to Linux in the future. It's no= t a show stopper but it's obviously an issue.=20 Chris Sent from my iPhone 5 > On Oct 20, 2016, at 4:18 PM, Jonathan Chen wrote: >=20 >> On 21 October 2016 at 09:09, Peter wrote: >> [...] >>=20 >> I see this on my pgsql_tmp dirs (where Postgres stores intermediate >> query data that gets too big for mem - usually lots of files) - in >> normal operation these dirs are completely empty, but make heavy disk >> activity (even writing!) when doing ls. >> Seems normal, I dont care as long as the thing is stable. One would need >> to check how ZFS stores directories and what kind of fragmentation can >> happen there. Or wait for some future feature that would do >> housekeeping. ;) >=20 > I'm seeing this as well with an Odoo ERP running on Postgresql. This > lag does matter to me as this is huge performance hit when running > Postgresql on ZFS, and it would be good to see this resolved. > pg_restores can make the system crawl as well. >=20 > Cheers. > --=20 > Jonathan Chen > _______________________________________________ > freebsd-stable@freebsd.org mailing list > https://lists.freebsd.org/mailman/listinfo/freebsd-stable > To unsubscribe, send any mail to "freebsd-stable-unsubscribe@freebsd.org"