Re: "Leaking" disk space on FreeBSD servers - Mailing list pgsql-general

From Vick Khera
Subject Re: "Leaking" disk space on FreeBSD servers
Date
Msg-id CALd+dcfOYxJoAettPVYJjb-u3UOC_VhM29fTqHiON_xW_FNzKw@mail.gmail.com
Whole thread Raw
In response to Re: "Leaking" disk space on FreeBSD servers  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
Responses Re: "Leaking" disk space on FreeBSD servers
List pgsql-general

On Wed, Mar 20, 2013 at 10:34 AM, Achilleas Mantzios <achill@matrix.gatewaynet.com> wrote:

regarding journaling, there is the counter argument that you do not need to do the same job twice,

in the sense that we already spend a considerable amount of time retaining the WAL in postgresql,

no need to redo the same on FS level.


There's a difference in the file system integrity and the DB integrity.  PG will keep the DB integrity just fine without the file system journaling. The journaling just makes recovery from crash that much faster.  ie, running fsck on 6TB of disk storage takes a LONG time, sometimes hours, but with the journal enabled, it takes a few seconds.

pgsql-general by date:

Previous
From: Achilleas Mantzios
Date:
Subject: Re: "Leaking" disk space on FreeBSD servers
Next
From: "jg"
Date:
Subject: Re: File Fragmentation