[Gdal-dev] PostGIS Driver Performance

Oleg Semykin oss-dev at rambler.ru
Thu Jul 28 08:47:31 EDT 2005


Hi Craig!

Why the PostgreSQL driver loads all non-system tables from the database 
as layers? When we have a lot of tables this results in too big 
overhead. When we are working with PostGIS all layers are listed in the 
geometry_columns table and we can use it to prepare a list of tables to 
load. I can modify the driver to load only layers from the 
geometry_columns table when we have PostGIS and fallback to the old 
behaviour when we have plain PostgreSQL.

Oleg.



More information about the Gdal-dev mailing list