Re: BUG #10734: PostgreSQL 9.3.4 shutdown forever in zfsonlinux 0.6.3-1 filesystem - Mailing list pgsql-bugs

From Tomas Vondra
Subject Re: BUG #10734: PostgreSQL 9.3.4 shutdown forever in zfsonlinux 0.6.3-1 filesystem
Date
Msg-id f19ec8b9a2a29d715d87760eaf426804.squirrel@sq.gransy.com
Whole thread Raw
In response to BUG #10734: PostgreSQL 9.3.4 shutdown forever in zfsonlinux 0.6.3-1 filesystem  (digoal@126.com)
Responses Re: BUG #10734: PostgreSQL 9.3.4 shutdown forever in zfsonlinux 0.6.3-1 filesystem  (德哥 <digoal@126.com>)
List pgsql-bugs
On 23 Červen 2014, 9:17, digoal@126.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

pgsql-bugs by date:

Previous
From: "Tomas Vondra"
Date:
Subject: Re: BUG #10736: Database does somtimes not startup again after restart
Next
From: Tom Lane
Date:
Subject: Re: BUG #10728: json_to_recordset with nested json objects NULLs columns