[postgis-users] out of memory

Bborie Park bkpark at ucdavis.edu
Thu Oct 25 09:49:18 PDT 2012


You may want to increase your shared_buffer to 25% of your system's
available memory.

You really should tile your raster.

-bborie

On 10/25/2012 02:19 AM, Mahavir Trivedi wrote:
>  i have 4 GB RAM                      WINDOWS XP 64-bit
> 
>  shared_buffer:512 MB   checkpoint_segment 32
> 
> work_mem;5MB
> 
>  i wish to import 540 MB tif image  into database postgis 2.0 . without tile .
> 
> i got success test.sql file. but error occured when psql -d dbname -f test.sql
> 
> error : String is 978678801 byte too long for encoding conversion
> 
> pls give any suitable solution
> 
> with thanks
> mahavir
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 

-- 
Bborie Park
Programmer
Center for Vectorborne Diseases
UC Davis
530-752-8380
bkpark at ucdavis.edu



More information about the postgis-users mailing list