From what I have gathered on the performance list, JFS seemed to be the
best overall choice, but I'd say check the archives of
pgsql-performance because so many of your I/O needs depends on what
you're going to be doing with your database.
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
Strategic Open Source — Open Your i™
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005
On Mar 28, 2005, at 12:29 AM, Joseph M. Day wrote:
Can anyone recemmend a filesystem to use for Postgres. I currently
have one table that has 80 mil rows, and will take roughly 8GB of
space without indexing. Obviously EXT3 will die for a file size this
large. Any suggestions with be helpful.
Thanks,
Joe,
--------------------------------------------
Joseph M. Day
Global Innovative Solutions
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
