[postgis-users] build a SDB cache for Spatial Database basedonpostgis and postgresql

Jan Syryn jan.syryn at trasys.be
Wed Nov 22 09:28:57 PST 2006


Mr Jackie,
 
My advice is (and a bit the same as Pedro):
 
If you are not very experienced but there is (lot of) money in the project:
don't hesitate and go for ORACLE / SPATIAL.
I offeres a very extended, stable, framework with zillion of features.
Furthermore, they offer a very quick and elaborate support system.
To conclude: VERY proffessional, but RATHER expensive.
 
If you wanna go for the 'cheap' version. Then Postgis is a choice. It still
has a rather fast update-cycle (this means it is not that stable yet).
But that is logic: it is open source.
Also support......... by the people like this little mailing list.
So not that professional, and above all (like Pedro indicated too): most of
the solutions you have to devine yourself and ask simple/small questions to
mailing list.
 
ArcView: same story: commercial, professional and licenced
 
Choice between Oracle or Arcview ? I don't know. First, I only worked with
Oracle/Spatial and that rockes as hell. Second, it depends on the budget and
other factors like:
- dimension (DB/DB-cluster ; mono-processors /multi-processors) (Oracle for
example is licenced by CPU)
- response time
- ..........
 
 

  _____  

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of zhang
Jackie
Sent: mercredi 22 novembre 2006 03:57
To: PostGIS Users Discussion
Subject: Re: [postgis-users] build a SDB cache for Spatial Database
basedonpostgis and postgresql


Mr.Pedro 
   your advice is very important for me an thank you very much for this.

   can you tell me how to profile the performance of PostGreSQL?
you say "Solutions are as good as the one who develops them" Do you mean
that my cooperative cache idea can not achieve expected performance? and so
this is a not a good idea? 
 
2006/11/22, Pedro Doria Meunier <pdoria at netmadeira.com>: 

Mr Jackie,

 

It's obvious you're pulling out straws since it's apparent that you don't
have a clue how to even benchmark Postgresql. 

 

Solutions are as good as the one who develops them.

My best advice to you is that, beyond asking for free papers/experience, you
should first take the time to experiment/study Posgresql and specifically
PostGIS extensions, know how to benchmark your own implementations and then
compare the same line of though with other products. 

 

Speaking strictly for myself, my company uses PG/PostGIS *extensively * with
tables spanning millions of records and we still tip the hat to the
PG/PostGIS developers.

Robustness is a given as well as scalability and stability. In short,
PG/PostGIS rocks! 

 

Building a SDB is more complex than you can now imagine and it's a
multidisciplinary task. 

 

Tip: start with asking small questions (reflecting your
commitment/investment to PG/PostGIS). This group is a very friendly bunch
(and helpful) when someone asks specific/informed questions. 

 

Sincerely,

Pedro Doria Meunier

(351) 91 302 49 72 - (351) 96 247 99 12

MSN - pdoriam at hotmail.com

ICQ - 308-182-126

Skype: pdoriam

 


  _____  


From: postgis-users-bounces at postgis.refractions.net [mailto:
<mailto:postgis-users-bounces at postgis.refractions.net>
postgis-users-bounces at postgis.refractions.net] On Behalf Of zhang Jackie
Sent: quarta-feira, 22 de Novembro de 2006 1:32
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] build a SDB cache for Spatial Database based
onpostgis and postgresql

 

    I am interesting in PostGis and want to do something on it. My idea is
to build a Spatial Database Cache to accelerate GIS applications .So I want
to ask you some question and hope to get your answer. 

    1. As we all know, PostGis is a Spatial extention for PostGreSQL. And
there are also some other products such as ArcSDE, Oracle Spatial .Have you
ever do some performance comparison between them.If you have ever done such
work,Could you give me some information on it. If not, is it because that
you team did not care about performance and just concerned with correctness
of the program. And if you can give me some materials on performance
comparison on such Spatial Database extention including ArcSDE, Oracle
Spatial ,MySQL ,etc. 

    2. Since Google Earth is lauched ,Many GIS systems are used by more and
more people,so the important features of Software becomes more and more
important,such as sacalibity, robust, stability,etc. Can you give me some
information and papers on the bottleneck of these applications.Especially,
are computing  and I/O requirements very important and become bottlenecks,Of
course, If you know some related solutions , you can mail me.

 I have searche lots of papers and get an overview of it. But I felt I did
not figure out the truth. So I want to get some more accurate information on
this field.  


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





-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20061122/1772944d/attachment.html>


More information about the postgis-users mailing list