Re: Linux Filesystem for PG

After a long battle with technology, jday(at)gisolutions(dot)us ("Joseph M. Day"), an earthling, 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.

Actually, it is common for "obvious" facts to be entirely incorrect.

-> ext3 wouldn't "die" with a file of that size; it supports files up
to about 2TB in size, and 8GB shouldn't be an "uncomfortable" size

-> PostgreSQL normally switches to a new file at 1GB intervals, so
that no file is ever larger than 1GB in size

That's not to say that ext3 would be my "favorite" for the purpose;
while I am not entirely decided as to the relative merits of JFS and
XFS, I'd generally prefer them to ext3.
--
let name="cbbrowne" and tld="gmail.com" in name ^ "@" ^ tld;;
http://linuxdatabases.info/info/slony.html
"If you haven't settled on your final year project, perhaps you would
like to write a C compiler that turns code into Turing machines : I
don't see anything wrong with that" -- Arthur Norman