[postgis-users] Best Filesystem?

[Craig Miller]

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