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

[zhang Jackie]

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:
> 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
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20061122/da5c8ac2/attachment.html>