Skip site navigation (1)Skip section navigation (2)
Date:      Thu, 20 Oct 2016 23:27:02 +0100
From:      Steven Hartland <killing@multiplay.co.uk>
To:        freebsd-stable@freebsd.org
Subject:   Re: zfs, a directory that used to hold lot of files and listing pause
Message-ID:  <92607b3b-a2d1-2391-5bd6-9781f426d7a6@multiplay.co.uk>
In-Reply-To: <CAJuc1zPJWAQbqQGLJdD_Zm_J8Z1tk_J9Tat7=%2BR90q37Ud54qA@mail.gmail.com>
References:  <4d9269af-ed64-bb73-eb7f-98a3f5ffd5a2@norma.perm.ru> <nub8aq$203d$1@oper.dinoex.de> <CAJuc1zPJWAQbqQGLJdD_Zm_J8Z1tk_J9Tat7=%2BR90q37Ud54qA@mail.gmail.com>

next in thread | previous in thread | raw e-mail | index | archive | help
On 20/10/2016 22:18, Jonathan Chen wrote:
> On 21 October 2016 at 09:09, Peter <pmc@citylink.dinoex.sub.org> 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?



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?92607b3b-a2d1-2391-5bd6-9781f426d7a6>