[postgis-users] PostgreSQL/PostGIS vs. Oracle

[Gregory S. Williamson]

Well, we found that Informix worked while Oracle (about two revs ago, admittedly) didn't; we've since migrated to postGIS and find that speed is about comparable.

Our datasets aren't quite as large as yours though, so YMMV. A lot of performance will depend on the spcificity of the indexes, spatial and otherwise.

Hardware: Opteron, lots of RAM, battery-backed cache and RAIDed disks. Try looking through the postgres performance mail list archives -- there have been a number of recent threads about hardware. RAID10 seems to be getting some preference... I personally advocate against RAID5 for data safety reasons. XEON seems to have some issues with memory swapping and the like -- best to avoid it. 

HTH,

Greg Williamson
DBA
GlobeXplorer LLC


-----Original Message-----
From:	postgis-users-bounces at postgis.refractions.net on behalf of sven_ger at users.sourceforge.net
Sent:	Mon 9/18/2006 11:07 AM
To:	postgis-users at postgis.refractions.net
Cc:	
Subject:	[postgis-users] PostgreSQL/PostGIS vs. Oracle

Hey all,
I'm looking for some information about the performance of
PostgreSQL/PostGIS vs. Oracle.

So at first some background information. I will store about
500.000.000 triangles, about 200.000 buildings LoD 2 (CityGML),....
You can say everything you need for an good citymodell ;)

I need some information about the performance. So what kind of
computer I need and so on. Especially which DBMS will be faster.

I hope you can help me! Is there maybe someone who is using
PostgreSQL/PostGIS for some similar things?

Thanks a lot,
Sven_ger



_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


-------------------------------------------------------
Click link below if it is SPAM gsw at globexplorer.com
"https://mailscanner.globexplorer.com/dspam/dspam.cgi?signatureID=450edfe0301708992556831&user=gsw@globexplorer.com&retrain=spam&template=history&history_page=1"
!DSPAM:450edfe0301708992556831!
-------------------------------------------------------