Skip site navigation (1) Skip section navigation (2)

Res: [GENERAL] bytea size limit?

From: paulo matadr <saddoness(at)yahoo(dot)com(dot)br>
To: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
Cc: GENERAL <pgsql-general(at)postgresql(dot)org>, admin <pgsql-admin(at)postgresql(dot)org>
Subject: Res: [GENERAL] bytea size limit?
Date: 2009-01-21 17:44:14
Message-ID: (view raw or whole thread)
Lists: pgsql-adminpgsql-general
The size of object depend on report  for a user request,
shared_buffers = 2048MB
work_mem = 12MB 

Server conf
Red Hat Enterprise Linux Server release 5

Using apliccation web based , with Jboss apliccation server on jdbc driver.
Lets see  scenario :
Apliccation request a report,if this bigger , hangs .
No able to select or others report in this table.


De: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
Para: paulo matadr  *EXTERN* <saddoness(at)yahoo(dot)com(dot)br>; pgsql-general(at)postgresql(dot)org; admin <pgsql-admin(at)postgresql(dot)org>
Enviadas: Quarta-feira, 21 de Janeiro de 2009 14:03:17
Assunto: Re: [ADMIN] [GENERAL] bytea size limit?

paulo matadr wrote:
> I everyone, need help!!!
> My aplication return erro:
> 2009-01-20 10:22:03,264 INFO  [STDOUT] Caused by: org.postgresql.util.
> PSQLException: ERROR: invalid memory alloc request size 1705447581
>  TABLE batch.relatorio_gerado 
>   rege_id integer NOT NULL,
>   fuin_id integer NOT NULL,
>   rela_id integer NOT NULL,
>   rege_tmultimaalteracao timestamp without time zone NOT NULL DEFAULT now(),
>   rege_nnpaginas integer NOT NULL,
>   rege_binario bytea,
>   rege_pdf bytea
> I get this erro above  refers the column "rege_pdf bytea"   , 
> when try generate report in pdf.

What are you doing in terms of SQL?

How big are the binary objects involved?

What are the values of the database parameters shared_buffers and work_mem?

Laurenz Albe

Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
To make changes to your subscription:

      Veja quais são os assuntos do momento no Yahoo! +Buscados

In response to


pgsql-admin by date

Next:From: Carol WalterDate: 2009-01-21 17:50:23
Subject: Re: ssl database connection problems...
Previous:From: Cédric VillemainDate: 2009-01-21 17:32:59
Subject: Re: PostgreSQL monitoring

pgsql-general by date

Next:From: Raymond C. RodgersDate: 2009-01-21 17:44:16
Subject: Re: Problem with retrieving records using double precision fields
Previous:From: Sam MasonDate: 2009-01-21 17:33:12
Subject: Re: Problem with retrieving records using double precision fields

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group