Build a Spatial Database Cache based on PostgreSQL and PostGIS
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!
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