On 23 Červen 2014, 9:17, digoal(at)126(dot)com wrote:
> it's a postgresql bug?
I doubt that. Most likely it's caused by the zfs filesystem, which has
interesting features but it's not exactly for free. Try to use some other
'traditional' filesystem (e.g. ext4 or xfs) and check how long it takes
with it.
There are ways to tune zfs, but pgsql-bugs is not the right list to
discuss that. Please ask in pgsql-performance.
regards
Tomas