文件系统EXT2或EXT3上的Postgresql

本文介绍了文件系统EXT2或EXT3上的Postgresql的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述 您好： 我想知道在文件系统为EXT2或EXT3的Linux系统上安装Postgresql 是否有任何不同。我有两台机器 与idential OS（Red Hat 7.3安装与postgresql 7.3.4）但与 不同的文件系统，1是EXT2，另一台是EXT3。当我向两台机器插入10,000 记录时，我发现EXT2的机器比EXT3的机器插入更快 。 postgresqk使用EXT2文件系统表现更好吗？ 非常感谢！ Carmen __________________________________________________ _______________ Linguaphone：学习英语？免费获得日语课程 http://go.msnserver.com /HK/30476.asp ---------------------------（播出结束） --------------------------- 提示7：别忘了增加免费空间地图设置 解决方案 使用ext2在文件系统上写入的任何内容都会更快。这是 也不太可靠。 A - ---- Andrew Sullivan 204-4141 Yonge Street Afilias Canada加拿大安大略省多伦多 < an **** @ libertyrms.info> M2P 2A8 [phone] x110 -------------------------- - （广播结束）--------------------------- 提示1：订阅和取消订阅命令转到 ma*******@postgresql.org Carmen， 考虑拥有日记文件系统安全性的开销 当你进行比较时。 Rich - Richard B. Shepard博士，总裁 Applied Ecosystem Services，Inc。（TM） < http://www.appl-ecosys.com> ---------------------------（广播结束）----------------- ---------- 提示6：您是否搜索了我们的列表档案？ http://archives.postgresql.org 请记住，对于日记类型的fs，你有额外的费用来支付期刊的b / b $ b。我之前听过人们发表评论，关于EXT 3比EXT 2慢了多少。我个人没有看到任何显着的减速但是对于 Linux keep记住你也可以使用ReiserFS，我听说在同一场景中比EXT 3更快。。 JFS也是一个选项。 您可能还想在EXT2 / 3文件系统上调整您的inode大小。 默认值为4k。我使用2k但你可以低至1k。那不是什么东西 你可以在飞行中做。你必须备份所有内容并重做 文件系统。 - Keith C. Perry，MS EE 网络总监&申请 VCSN，Inc。 http://vcsn.com ____________________________________ 此电子邮件帐户由以下人员主持： VCSN，Inc： http://vcsn.com ---------- -----------------（广播结束）--------------------------- 提示3：如果通过Usenet发布/阅读，请发送适当的 subscribe-nomail命令到 ma ******* @ postgresql.org ，以便您的 消息可以干净地通过邮件列表 Hello: I would like to know whether there is any different in installing Postgresqlon the Linux system with file system of EXT2 or EXT3. I have two machineswith idential OS (Red Hat 7.3 install with postgresql 7.3.4) but withdifferent file system, 1 is EXT2 and the other is EXT3. When I insert 10,000records to the two machines, I found that the machine with EXT2 insert muchquicker than the other with EXT3. Is postgresqk perform better with EXT2 file system? Thanks a lot!Carmen __________________________________________________ _______________Linguaphone : Learning English? Get Japanese lessons for FREE http://go.msnserver.com/HK/30476.asp---------------------------(end of broadcast)---------------------------TIP 7: don''t forget to increase your free space map settings 解决方案 Anything that writes on the filesystem is faster with ext2. It''salso less reliable. A ------Andrew Sullivan 204-4141 Yonge StreetAfilias Canada Toronto, Ontario Canada<an****@libertyrms.info> M2P 2A8+1 416 646 3304 x110---------------------------(end of broadcast)---------------------------TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org Carmen, Consider the overhead in having the security of a journaling file systemwhen you make your comparisons. Rich --Dr. Richard B. Shepard, PresidentApplied Ecosystem Services, Inc. (TM)<http://www.appl-ecosys.com> ---------------------------(end of broadcast)---------------------------TIP 6: Have you searched our list archives? http://archives.postgresql.org Keep in mind that with a journaling type fs, you have additional overhead forthe journal. I''ve heard people make this comment before about EXT 3 beingslower that EXT 2. I personally haven''t seen any signficant slow down but forLinux keep in mind that you could also use ReiserFS which I''ve heard is fasterthan EXT 3 in the same scenario. JFS is also an option. You might also want to adjust your inode size down on the EXT2/3 filesystems.The default is 4k. I use 2k but you can go as low as 1k. Thats not somethingyou can do on the fly though. You''ll have to backup everything and redo thefilesystem. --Keith C. Perry, MS E.E.Director of Networks & ApplicationsVCSN, Inc. http://vcsn.com ____________________________________This email account is being host by:VCSN, Inc : http://vcsn.com ---------------------------(end of broadcast)---------------------------TIP 3: if posting/reading through Usenet, please send an appropriatesubscribe-nomail command to ma*******@postgresql.org so that yourmessage can get through to the mailing list cleanly 这篇关于文件系统EXT2或EXT3上的Postgresql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！