[postgis-users] Insert data larger than 1 Gig...

[chodgson@refractions.net]

Nick,

Why do you want a single field of data to have over one gigabyte of data? What 
is the point? Might as well just put a filename in the database and dump the 
data to a file. You need to tile your data in order to take advantage of any of 
the features of a database - in particular, spatial indexing.

I have a feeling that postgis has some upper limit on the size of a query, 
probably less than a gigabyte, I wouldn't even try to insert something that big.

Chris


Quoting Nick Ton <nton@photon.com>:

> 
> 
> Hi,
> 
> This email is a revisit of my previous question about raster
> image data storage in PostGIS. Based on David's (David Blasby)
> detailed reply, I was able to successfully insert and retrieve
> DTED data with considerable ease from PostGIS. However, we have
> data that far exceed the 1 Gigabyte size. So now I am faced with
> a problem of trying to convert the binary data into hexadecimal
> ASCII representation in memory which cause an out of memory exception.
> So I was wondering if there's a way around this problem. My first thought
> is to read a chunck of raster data at a time and convert it from binary to
> hexadecimal text byte by byte. However, this doesn't solve the problem of
> creating a SQL insert statement that has a 1 Gigabyte or greater data
> field. So my question is - is there a way to insert data into PostGIS
> using a SQL Insert statement that has a field data greater than 1 Gigabyte
> or exceeds the on-line memory of your computer?
> 
> Nick
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>