Postgres Pro
Downloads
Home   >   mailing lists

out of memory - Mailing list pgsql-performance

From Mahavir Trivedi
Subject out of memory
Date
Msg-id CAK9do=wt-yZ2MrbgBwjhqMv-Be_UaFCO95K1MsB5-g2aZ26-BA@mail.gmail.com
Whole thread Raw
Responses Re: out of memory  (Tatsuo Ishii <ishii@postgresql.org>)
List pgsql-performance
Tree view
hi 


i have sql file (it's size are 1GB  )
when i execute it then the String is 987098801 bytr too long for encoding conversion  error occured .
pls give me solution about 

i have XP 64-bit with 8 GB RAM shared_buffer  1GB  check point = 34 


with thanks
mahavir

pgsql-performance by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: Request for help with slow query
Next
From: vignesh
Date:
Subject: PostgreSQL server failed to start