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.
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 |