PostGIS vs. Shapefile

[Lyndon Tiu]

On February 10, 2005 06:49 am, Daniele Margotti wrote:
> It didn't work: same long time...
>
> I also ran this commands (for every table):
>
> SELECT UPDATE_GEOMETRY_STATS('mytable', 'the_geom');
>
> but I didn't get a better performance.
>

Did you tune Postgresql?

Postgresql is like Oracle, the default parameters are always never sufficient
for your specific needs.

Go to goggle and type Performance Tuning Postgresql.

Look into the file located under:

<postgresql_data_home>/postgresql.conf

This file contains the important tuning parameters.

--
Lyndon Tiu