Raster tile indexing in PostGIS

[Paul Ramsey]

I generally agree with Frank, but I have had one anecdotal report from a 
user that they found PostGIS faster than Shape files on plain old read 
operations once the concurrency cranked up.

Now, I can think of no technical reason why that might be so, and I have 
never independently verified the report, but it is something that keeps 
me from blanket saying "Shape files are faster for simple read 
workloads" anymore.

(Maybe someone here can do a test?)

P

Thy, Kristian wrote:
> From: Frank Warmerdam
>> Generally speaking the shapefiles, and the spatial indexes will get
>> cached in RAM.
> 
> Also for separate invocations of cgi MapServer? Pardon if this is a
> stupid question, but the arcane workings of computer hardware is not
> my area of expertise :-)
> 
> Kristian
> 
> 
> This email and any attached files are confidential and copyright
> protected. If you are not the addressee, any dissemination of this
> communication is strictly prohibited. Unless otherwise expressly
> agreed in writing, nothing stated in this communication shall be
> legally binding.