Skip site navigation (1)Skip section navigation (2)
Date:      Fri, 21 Oct 2016 10:18:52 +1300
From:      Jonathan Chen <jonc@chen.org.nz>
To:        Peter <pmc@citylink.dinoex.sub.org>
Cc:        freebsd-stable@freebsd.org
Subject:   Re: zfs, a directory that used to hold lot of files and listing pause
Message-ID:  <CAJuc1zPJWAQbqQGLJdD_Zm_J8Z1tk_J9Tat7=%2BR90q37Ud54qA@mail.gmail.com>
In-Reply-To: <nub8aq$203d$1@oper.dinoex.de>
References:  <4d9269af-ed64-bb73-eb7f-98a3f5ffd5a2@norma.perm.ru> <nub8aq$203d$1@oper.dinoex.de>

next in thread | previous in thread | raw e-mail | index | archive | help
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.

Cheers.
-- 
Jonathan Chen <jonc@chen.org.nz>



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?CAJuc1zPJWAQbqQGLJdD_Zm_J8Z1tk_J9Tat7=%2BR90q37Ud54qA>