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

From Thomas F.O'Connell
Subject Re: Linux Filesystem for PG
Date
Msg-id 6d389fbedc5b65125801193ba61f039a@sitening.com
Whole thread Raw
In response to Linux Filesystem for PG  ("Joseph M. Day" <jday@gisolutions.us>)
List 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


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Can't pg_dumpall, claims database exists twice
Next
From: Mike Rylander
Date:
Subject: Re: general purpose full text indexing