[Gdal-dev] PostGIS Driver Performance

Frank Warmerdam fwarmerdam at gmail.com
Thu Jul 28 09:47:26 EDT 2005


On 7/28/05, Oleg Semykin <oss-dev at rambler.ru> wrote:
> 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, 

I would be agreeable to such a change in the behavior of 
OGRPGDataSource::Open().  

Best regards,
-- 
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | Geospatial Programmer for Rent




More information about the Gdal-dev mailing list