out of memory

From: Mahavir Trivedi <mahavir(dot)trivedi(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: out of memory
Date: 2012-10-30 09:14:49
Message-ID: CAK9do=wt-yZ2MrbgBwjhqMv-Be_UaFCO95K1MsB5-g2aZ26-BA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tatsuo Ishii 2012-10-30 10:08:59 Re: out of memory
Previous Message jesper 2012-10-30 08:17:48 Re: WIP checksums patch

Browse pgsql-performance by date

  From Date Subject
Next Message vignesh 2012-10-30 09:24:00 PostgreSQL server failed to start
Previous Message Albe Laurenz 2012-10-30 09:02:19 Re: Request for help with slow query