From: jtkells@verizon.net
To: pgsql-admin@postgresql.org
Subject: Problem retrieving large records (bytea) data from a table
Date: Tue, 05 Jul 2011 12:44:24 -0400
Message-ID: <bnf617dql1hq15cd8vlqdnngdkejtechhg@4ax.com> (raw)
I am having a hang condition every time I try to retrieve a large
records (bytea) data from a table
The OS is a 5.11 snv_134 i86pc i386 i86pc Solaris with 4GB memory
running Postgresql 8.4.3 with a standard postgresql.conf file (nothing
has been changed)
I have the following table called doc_table
Column | Type | Modifiers |
Storage | Description
------------------------+--------------------------------+---------------------------------------
id | numeric | not null | main |
file_n | character varying(4000) | |
extended |
create_date | timestamp(6) without time zone | not null
default (clock_timestamp())
::timestamp(0)without time zone | plain |
desc | character varying(4000) | |
extended |
doc_cc | character varying(120) | not null |
extended |
by | numeric | not null | main |
doc_data | bytea | |
extended |
mime_type_id | character varying(16) | not null |
extended |
doc_src | text | |
extended |
doc_stat | character varying(512) | not null
default 'ACTIVE'::character varying |
extended |
Indexes:
"documents_pk" PRIMARY KEY, btree (document_id)
A while ago the some developers inserted several records with a
document (stored in doc_Data) that was around 400 - 450 MB each. Now
when you do a select * (all) from this table you get a hang and the
system becomes unresponsive. Prior to these inserts, a select * (all,
no where clause) worked. I'm also told a select * from doc_table
where id = xxx still works. I haven't seen any error message in the
postgresql log files.
So I'm not sure how to find these bad records and why I am getting a
hang. Since this postgresql is running with the default config files
could I be running out of a resource? If so I'm not sure how to or
how much to add to these resources to fix this problem since I have
very little memory on this system. Does anyone have any ideas why I
am getting a hang. Thanks
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jtkells@verizon.net
Subject: Re: Problem retrieving large records (bytea) data from a table
In-Reply-To: <bnf617dql1hq15cd8vlqdnngdkejtechhg@4ax.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox