[Gdal-dev] OGR PostGIS driver BINARY CURSOR support

Oleg Semykin oss-dev at rambler.ru
Sat Aug 6 10:53:08 EDT 2005


Hi, Frank!! Hi ALL!

I am just finished the binary cursor support for PostGIS.

This support is switched off by default.
To switch it ON, you have to replace two first character of driver 
string ('PG') with ('PGB') -> PG Binary

For example:
ogrinfo 'PGB:host=192.168.17.3 dbname=lenobl user='postgres' password='' 
port=5432' t_table_10

Everybody is welcome to test this feature for a bugs and performance.

I am have tables with only ~5000 records of complex geometries ( 
MULTIPOLYGON)
And that is my results:

oss at oss:~/work/gis/gdal$ time ogrinfo 'PG:host=192.168.17.3 
dbname=lenobl user='postgres' password='' port=5432' t_table_10 > 
/dev/null 2>&1

real    0m17.252s
user    0m2.214s
sys     0m0.162s

oss at oss:~/work/gis/gdal$ time ogrinfo 'PGB:host=192.168.17.3 
dbname=lenobl user='postgres' password='' port=5432' t_table_10 > 
/dev/null 2>&1

real    0m9.504s
user    0m1.969s
sys     0m0.165s

I would be very thankful for any suggestions.



More information about the Gdal-dev mailing list