From owner-freebsd-stable@freebsd.org Thu Oct 20 22:26:39 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 78A72C1B5E7 for ; Thu, 20 Oct 2016 22:26:39 +0000 (UTC) (envelope-from killing@multiplay.co.uk) Received: from mail-lf0-x231.google.com (mail-lf0-x231.google.com [IPv6:2a00:1450:4010:c07::231]) (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 F40CD7E4 for ; Thu, 20 Oct 2016 22:26:38 +0000 (UTC) (envelope-from killing@multiplay.co.uk) Received: by mail-lf0-x231.google.com with SMTP id b81so103736984lfe.1 for ; Thu, 20 Oct 2016 15:26:38 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=multiplay-co-uk.20150623.gappssmtp.com; s=20150623; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to; bh=Brgjd+8aMljf9vJ+h1R62UYCNdX/UtTBUAt1fQosF9I=; b=s9kPHvoCtMQBRuGtTsr0cfhlypB1dJXq+ET60DiBr5IHvEQTGjW7hIaNydd+6VRMT+ yYM46S/Jur3ilZLZVFBpN9puDgMBWFqFryN2anTaJMzrJONSmj4hxgi4H9D3zYR6Slad CsNGGaKVe5qpELz9aAVu84Tp+zMpxoQz2RZLFOwvtEryBqdk3lkRpXNhbH6z2CoSqQrB 9CrAAXTQgnGl4CWl5SI/Ltmt4uWa9Q3wJSeg70/6wsttzg3bJpMMKHX1qnZriFcQdTUK jBKYSaw2Ha1IrSXm7811TALyksKPkU2/HjbA86PyBJ7yiNK6ew0RUOJsGQsQxHGJQWQS j4qQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to; bh=Brgjd+8aMljf9vJ+h1R62UYCNdX/UtTBUAt1fQosF9I=; b=hPoZJpwAX/gm3+i7AQVncrKuSY1O03DqAnOilmREjCGIcoBsjmrIymtWEBnAHmjnFS +TOdPl/4rn+ReADO2V8n6KVzwmuCnvE8a7KXj8GZGD0QlPsn7yvch06xP07MaOtvoK/p QxnCmeFkmfvDmsShZmCGWUG7qTjxcO/2xacWfHRX/86BYKvRioTOgpIWc3rC/Zc4B9P+ kFPn8ssYc7u8nhbk0L5HhDKg6K2TO1nJROm4atkmMOTCNrMIu3QEa18tQMovQ4f3eqYa JRbDpeAO0ZHc6mg2lJ8hiu+8B7CzdpGUVOfENxurlJmOwUWRLucadiByhvnHcoA3QBwW 0vAw== X-Gm-Message-State: AA6/9RkeZeEJMkvD/wrJOLHDohNt6OqXUeF+rj58Ozi18TXaxqt5HvYVA1JXpmni039PE4Iy X-Received: by 10.28.158.203 with SMTP id h194mr291283wme.59.1477002393802; Thu, 20 Oct 2016 15:26:33 -0700 (PDT) Received: from [10.10.1.58] ([185.97.61.26]) by smtp.gmail.com with ESMTPSA id us3sm81856679wjb.32.2016.10.20.15.26.32 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Thu, 20 Oct 2016 15:26:32 -0700 (PDT) Subject: Re: zfs, a directory that used to hold lot of files and listing pause To: freebsd-stable@freebsd.org References: <4d9269af-ed64-bb73-eb7f-98a3f5ffd5a2@norma.perm.ru> From: Steven Hartland Message-ID: <92607b3b-a2d1-2391-5bd6-9781f426d7a6@multiplay.co.uk> Date: Thu, 20 Oct 2016 23:27:02 +0100 User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:45.0) Gecko/20100101 Thunderbird/45.4.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 7bit X-Content-Filtered-By: Mailman/MimeDel 2.1.23 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:26:39 -0000 On 20/10/2016 22:18, Jonathan Chen wrote: > 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. As mentioned before could you confirm you have disable atime?