Re: Build a Spatial Database Cache based on PostgreSQL and PostGIS

On Nov 20, 2006, at 10:15 PM, zhang Jackie wrote:
> hi,everyone!
>    I want to build a Spatial Database Cache based on PostgreSQL and  
> PostGIS to accelerate GIS application.But I did not found related  
> work while many people build cache for Oracle DB2 ,such business  
> Ralational DBMS. Do someone know or have done such related work to  
> have a good discussion or give some good advice. My idea is that  
> cache  can solve the problem of computing problem and I/O  
> bottleneck and some detail need be proved .Hoping your advice!


I know a considerable amount about scalable GIS applications,  
including PostgreSQL and PostGIS based systems.  We have done  
extensive profiling and testing of high-performance GIS server  
designs in conjunction with some other companies, but I am not sure  
exactly what you are asking.  PostgreSQL and PostGIS are a reasonable  
foundation for this type of system design.  There *are* significant  
scalability bottlenecks, both system specific and as a general limit  
of the algorithms in common use, so it is not a small topic.

What, specifically, are you trying to do and what problems are you  
attempting to solve?

Cheers,

J. Andrew Rogers
jrogers@neopolitan.com