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: 874436.25662.qm@web52503.mail.re2.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-general
The size of object depend on report  for a user request,
shared_buffers = 2048MB
work_mem = 12MB 

-------
Server conf
16 GB RAM
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?
INSERT, UPDATE, DELETE?

How big are the binary objects involved?

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

Yours,
Laurenz Albe

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



      Veja quais são os assuntos do momento no Yahoo! +Buscados
http://br.maisbuscados.yahoo.com

In response to

Responses

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-2014 The PostgreSQL Global Development Group