Re: Linux Filesystem for PG

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

In response to

Browse pgsql-general by date

  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