| From: | Vick Khera <vivek(at)khera(dot)org> |
|---|---|
| To: | Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: "Leaking" disk space on FreeBSD servers |
| Date: | 2013-03-20 14:39:58 |
| Message-ID: | CALd+dcfOYxJoAettPVYJjb-u3UOC_VhM29fTqHiON_xW_FNzKw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Mar 20, 2013 at 10:34 AM, Achilleas Mantzios <
achill(at)matrix(dot)gatewaynet(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | jg | 2013-03-20 14:47:34 | Re: File Fragmentation |
| Previous Message | Thomas Kellerer | 2013-03-20 14:35:06 | Re: File Fragmentation |