Search Postgresql Archives

Re: Would it be OK if I put db file on a ext2 filesystem?

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

 



Magicloud Wang wrote:
Dear,
I think database has its own operation journal, and different journal filesystem does give different performance. So if I put database file on a non-journal filesystem, would it be safe? Does this like using a raw device?


You lose a little bit of data integrity in exchange for a little bit of speed. I suppose it'd be a fine thing to do so long as you can live with that trade off. If you want good data integrity you are more likely to get it from battery backed RAID5 or RAID10 or something of that sort rather than just trusting something like EXT3 or Reiser. EXT2 isn't a bad file system.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
      message can get through to the mailing list cleanly

[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