[GRASS5] Re: [Gdal-dev] OGR PostGIS driver BINARY CURSOR support

[Markus Neteler]

This FWD from GDAL-dev is probably of interest here.

http://lists.maptools.org/pipermail/gdal-dev/2005-August/thread.html#6122

Markus

On Sat, Aug 06, 2005 at 06:53:08PM +0400, Oleg Semykin wrote:
> 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.
>