Re: pg_restore out of memory

From: Francisco Reyes <lists(at)stringsutils(dot)com>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Vivek Khera <vivek(at)khera(dot)org>, PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_restore out of memory
Date: 2007-06-19 18:41:37
Message-ID: cone.1182278497.186236.90929.5001@35st.simplicato.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Alvaro Herrera writes:

> Can you send the program along? And the table definition (including
> indexes, etc)?

I put the table definition and a Python program that reproduces the problem
at:

http://public.natserv.net/table-schema.sql
http://public.natserv.net/large_record.py

The program uses the psycopg2 library.
All the program does is to send test data to the table, in particular doing
a large text size for a text column called attachment_body.

The database doesn't give an out of error message like when trying to run a
copy, but instead generates a lot output to the log such as
http://public.natserv.net/postgresql-2007-06-19.txt

The out of memory error when trying to use the copy command is
http://public.natserv.net/postgresql-2007-06-15.log

Thanks for any further pointers and suggestions.
Don't know what else to try at this point.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2007-06-19 19:35:47 Re: [GENERAL] Looking for Graphical people for PostgreSQL tradeshow signage
Previous Message John K Masters 2007-06-19 18:14:13 Re: initdb