Re: Linux Filesystem for PG - Mailing list pgsql-general

From Christopher Browne
Subject Re: Linux Filesystem for PG
Date
Msg-id 3artkeF6dlt87U1@individual.net
Whole thread Raw
In response to Linux Filesystem for PG  ("Joseph M. Day" <jday@gisolutions.us>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: sorting Chinese varchar field
Next
From: Bruno Wolff III
Date:
Subject: Re: sub query constraint