Re: Linux Filesystem for PG

From: Christopher Browne <cbbrowne(at)acm(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Linux Filesystem for PG
Date: 2005-03-29 02:42:23
Message-ID: 3artkeF6dlt87U1@individual.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2005-03-29 04:15:20 Re: sub query constraint
Previous Message Tatsuo Ishii 2005-03-29 01:25:58 Re: sorting Chinese varchar field