Search Postgresql Archives

Re: "Leaking" disk space on FreeBSD servers

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Of course, but does it make sense for you to pay the ~ 5%/day performance penalty for the ~0.5%/year chance of having your system crush?

Unless your FreeBSD server is stuffed with exotic gamer hardware, i don't see the likehood of crush getting larger than that.

 

On Τετ 20 Μαρ 2013 10:39:58 Vick Khera wrote:


On Wed, Mar 20, 2013 at 10:34 AM, Achilleas Mantzios <achill@xxxxxxxxxxxxxxxxxxxxx> 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.




-

Achilleas Mantzios

IT DEV

IT DEPT

Dynacom Tankers Mgmt


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux