From owner-freebsd-stable@freebsd.org Thu Oct 20 21:18:53 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 D30A5C1A522 for ; Thu, 20 Oct 2016 21:18:53 +0000 (UTC) (envelope-from jonc@chen.org.nz) Received: from mail-it0-x22c.google.com (mail-it0-x22c.google.com [IPv6:2607:f8b0:4001:c0b::22c]) (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 A52FCFA9 for ; Thu, 20 Oct 2016 21:18:53 +0000 (UTC) (envelope-from jonc@chen.org.nz) Received: by mail-it0-x22c.google.com with SMTP id m138so118235393itm.0 for ; Thu, 20 Oct 2016 14:18:53 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=chen-org-nz.20150623.gappssmtp.com; s=20150623; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=89FTUVWG4zxiJ6P+HMPoNFZUxmn9F4QUZjeJFWeyO60=; b=MEukHmiV+smD6ZTqV8AAmmQaBeRZG8YEvOnU+D6RKyoxFSRVMuhOKrz4qlasR6ZCd1 MmgEaLzCT87iSJ+PsT1BMXH7i8k349XOtE+ajhdxRJu2iv2LDA+YI+Gv7HUgrIzbucNi uHtqT17/qu+vsAYj+UPapvPv/Umrh+uyJlDzpTKeRs72v+AWAjqLm6Bf5U4d+TSZOfEr qeB4/CLlppmVzMgtMPdf8tNLNLAjMo6+VRt5Qm6g0gBA4rHxBYwEraLBKYAw44NjwnT0 ApEWk2EqWKa5w7QTzCAra1/nQxFtkXOobAQTgqhsuiHMa0MKkw1bMRl7FNzV+ixgTtq6 TE3Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=89FTUVWG4zxiJ6P+HMPoNFZUxmn9F4QUZjeJFWeyO60=; b=OOQaXHwft4/Mtt9FAP99F9TZahOZIg5KpXDyvWhnS5SkgB5JbaWKEak+tSW+wgahrz iwdiB86NToQfHqcGJnheEN9X10VxBHFx9z+Y5dbObyvyDrpj1hrPVZGqg1DI/WMyboqq dks0kW/KJhQWdcpgl4B6rCC+FmWynWTcrWTVuVx1/xfVnJiNLZgS4Ztc3zyzOIzT8K0i 7LfNXaqmc9Af3JMoZmq/Yinz9yKPs+7GEoZjiXirYtzM3+Pv5+8b1wI69P1GG57cBvmt GrFAXHZna2O6zX5DnasWeCTOxJdxs3EujDhgaUy7BMcQ34R6fJDLTRy1Xxi1cWJE7pFG jjIQ== X-Gm-Message-State: AA6/9Rmk2bmzwKwxXnYeD7iY4bpmvUdJSTMW7GA3b8akRJ72IFAJIXdjdS/85Slm8WbkYILMvoafhmchjEKWZw== X-Received: by 10.36.250.195 with SMTP id v186mr9910937ith.119.1476998333006; Thu, 20 Oct 2016 14:18:53 -0700 (PDT) MIME-Version: 1.0 Received: by 10.79.38.87 with HTTP; Thu, 20 Oct 2016 14:18:52 -0700 (PDT) X-Originating-IP: [203.99.129.1] In-Reply-To: References: <4d9269af-ed64-bb73-eb7f-98a3f5ffd5a2@norma.perm.ru> From: Jonathan Chen Date: Fri, 21 Oct 2016 10:18:52 +1300 Message-ID: Subject: Re: zfs, a directory that used to hold lot of files and listing pause To: Peter Cc: freebsd-stable@freebsd.org Content-Type: text/plain; charset=UTF-8 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 21:18:53 -0000 On 21 October 2016 at 09:09, Peter wrote: [...] > > 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. ;) 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. Cheers. -- Jonathan Chen