weecology/retriever

Compare copy vs insert for raster2pgsql

Closed this issue · 3 comments

henrykironde commented

retriever/retriever/engines/postgres.py

Line 169 in e277c74

raster_sql = ('raster2pgsql -Y -M -d -I -s {SRID} "{path}"' 

        raster_sql = ('raster2pgsql -Y -M -d -I -s {SRID} "{path}"'
        raster_sql = ('raster2pgsql -M -d -I -s {SRID} "{path}"'

-Y Use COPY statements instead of INSERT statements.

Mohitkumar6122 commented

@henrykironde Could you elaborate on what we have to do in this issue?

henrykironde commented

This is a performance test to compare what the better command is

henrykironde commented

We have moved on with Y Copy.