From: | Thomas F(dot)O'Connell <tfo(at)sitening(dot)com> |
---|---|
To: | "Joseph M(dot) Day" <jday(at)gisolutions(dot)us> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Linux Filesystem for PG |
Date: | 2005-03-28 19:30:42 |
Message-ID: | 6d389fbedc5b65125801193ba61f039a@sitening.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Mike Rylander | 2005-03-28 19:40:20 | Re: general purpose full text indexing |
Previous Message | Tom Lane | 2005-03-28 19:25:14 | Re: Can't pg_dumpall, claims database exists twice |