[postgis-users] Best Filesystem?

[Gerry Creager N5JXS]

Interesting question, and a good one.  I recently took a RAID5 box back 
to ext2 to remove the OS caching for performance...

gerry

Craig Miller wrote:
> Hi,
> 
> Has anyone benchmarked different filesystems with PostGIS?
> 
> I have read that JFS offers the best performance for PostgreSQL, followed
> closely by XFS.
> 
> It is interesting... I am finding that almost every layer in the stack is
> doing some form of caching and flushing.  I haven't checked to see what my
> hard drives themselves are doing, but my RAID controller caches,
> XFS/ReiserFS caches, and PostgreSQL caches.  While cacheing is generally a
> good thing, it is bad if it is a) redundant or b) exposing me unnecessary
> risk.  The latter is my largest concern.  If my system has it's power cord
> bumped, I don't want to lose the data that is floating around in a cache.
> 
> So, what is the "best" filesystem for running PostGIS based on performance
> and data integrity.
> 
> Looking forward to the responses,
> --Craig
> 
> 
> -----Original Message-----
> From: Wood Brent [mailto:pcreso at pcreso.com]
> Sent: Thursday, April 22, 2004 9:49 AM
> To: postgis-users at postgis.refractions.net
> Subject: Re: [postgis-users] interoperability/compatibility
> 
> 
> 
> 
> 
>>Dear users
>>
>>Can someone comment on general compatibility/interoperability of OSS with
>>other OSS or with the preoprietary systems.
> 
> 
> Perhaps useful references (pertaining to PostGIS) would be:
> 
> http://qgis.sourceforge.net/docs/install.html
> 
> QGIS is a simple GUI which allows you to look at PostGIS data, and import
> data
> from shapefiles intp PostGIS tables. It uses PostGIS, Postgres, GDAL, Proj4,
> GEOS, Qt to work together to create a GIS suite from interoperating
> components.
> 
> The install guide describes the intallation of each of these components to
> build the whole system.
> 
> 
> http://www.ing.unitn.it/~grass/conferences/GRASS2002/proceedings/proceedings
> /pdfs/Blazek_Radim.pdf
> 
> This paper was presented at a GRASS conference a couple of years ago. GRASS
> is perhaps the premier OpenSource GIS package, certainly in terms on
> longevity
> &
> overall functionality. It describes the new vector data capability which is
> based on PostGIS as the spatial vector data management tool.
> 
> 
> http://www-stat.uni-klu.ac.at/~agebhard/preDSC2003.pdf
> 
> This contains the preliminary slides from a presentation about integrating
> PostGIS and R (the open source stats package)
> 
> 
> www.safe.com/reader_writerPDF/postgis.pdf
> 
> FME from SAFE is pobably the most complete commercial GIS data reformatter
> available. They now support PostGIS as a standard geographic data source.
> 
> 
> There are plenty of others, UMN mapserver supports PostGIS, in a similar
> fashion to QGIS, so web mapping is also there.
> 
> 
> Hopefully a few useful examples....
> 
> Brent Wood
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> 
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

-- 
Gerry Creager -- gerry.creager at tamu.edu
Network Engineering -- AATLT, Texas A&M University	
Cell: 979.229.5301 Office: 979.458.4020 FAX: 979.847.8578
Page: 979.228.0173
Office: 903A Eller Bldg, TAMU, College Station, TX 77843