Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id D9E69632532 for ; Wed, 21 Jan 2009 13:44:21 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 68360-03 for ; Wed, 21 Jan 2009 13:44:18 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from web52503.mail.re2.yahoo.com (web52503.mail.re2.yahoo.com [206.190.48.186]) by mail.postgresql.org (Postfix) with SMTP id 766D6632495 for ; Wed, 21 Jan 2009 13:44:16 -0400 (AST) Received: (qmail 32379 invoked by uid 60001); 21 Jan 2009 17:44:14 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com.br; h=X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:Cc:MIME-Version:Content-Type:Message-ID; b=DC4k0vmhq6Kx9IWzAh9A++vuVlxQ94yxjVTc0iyqj4Mk9CwtGYlA0EiXgiWiGFAJUKatqG4DpiMKC4a3OzkxbX+ehDSmsWYuOt5d6HmmQrKtvdBDETA9nZsO8sZtmVNwsOcyNHLIfhro9NwCrOWJJ+S8SjGbIxSNRXxrQ52Mk3w=; X-YMail-OSG: RTMpa40VM1kuNOvvvtBTFTy.SGP0ziRGx_ZsvoQzZlI0AHSAKxrVQI8kiBqJOY7LU1sZB7VLCDmQSSgDZu6QATkvRxpuZnPlW5Osr4NFFOeZDIlJJL59rm535bpM3ELztxoYrVojI.JQKPubKYj3Gvmee6wKeoPz9kDs7fprNOcqIGpce0WOI6idpPuQX_oEjG3Khej73m8hFYr3LQ-- Received: from [189.17.249.3] by web52503.mail.re2.yahoo.com via HTTP; Wed, 21 Jan 2009 09:44:14 PST X-Mailer: YahooMailRC/1155.45 YahooMailWebService/0.7.260.1 References: <359812.4771.qm@web52512.mail.re2.yahoo.com> Date: Wed, 21 Jan 2009 09:44:14 -0800 (PST) From: paulo matadr Subject: Res: [GENERAL] bytea size limit? To: Albe Laurenz Cc: GENERAL , admin MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-192846743-1232559854=:25662" Message-ID: <874436.25662.qm@web52503.mail.re2.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200901/102 X-Sequence-Number: 31149 --0-192846743-1232559854=:25662 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable The size of object depend on report for a user request,=0Ashared_buffers = =3D 2048MB=0Awork_mem =3D 12MB =0A=0A-------=0AServer conf=0A16 GB RAM=0ARe= d Hat Enterprise Linux Server release 5=0A=0AUsing apliccation web based , = with Jboss apliccation server on jdbc driver.=0ALets see scenario :=0AApli= ccation request a report,if this bigger , hangs .=0ANo able to select or ot= hers report in this table.=0A=0A=0A =0A=0A=0A=0A=0A=0A=0A=0A=0A____________= ____________________=0ADe: Albe Laurenz =0APara: p= aulo matadr *EXTERN* ; pgsql-general@postgresql.or= g; admin =0AEnviadas: Quarta-feira, 21 de Janei= ro de 2009 14:03:17=0AAssunto: Re: [ADMIN] [GENERAL] bytea size limit?=0A= =0Apaulo matadr wrote:=0A> I everyone, need help!!!=0A> My aplication retur= n erro:=0A> =0A> 2009-01-20 10:22:03,264 INFO [STDOUT] Caused by: org.post= gresql.util.=0A> PSQLException: ERROR: invalid memory alloc request size 17= 05447581=0A> =0A> =0A> TABLE batch.relatorio_gerado =0A> =0A> rege_id in= teger NOT NULL,=0A> fuin_id integer NOT NULL,=0A> rela_id integer NOT N= ULL,=0A> rege_tmultimaalteracao timestamp without time zone NOT NULL DEFA= ULT now(),=0A> rege_nnpaginas integer NOT NULL,=0A> rege_binario bytea,= =0A> rege_pdf bytea=0A> =0A> I get this erro above refers the column "re= ge_pdf bytea" , =0A> when try generate report in pdf.=0A=0AWhat are you d= oing in terms of SQL?=0AINSERT, UPDATE, DELETE?=0A=0AHow big are the binary= objects involved?=0A=0AWhat are the values of the database parameters shar= ed_buffers and work_mem?=0A=0AYours,=0ALaurenz Albe=0A=0A-- =0ASent via pgs= ql-admin mailing list (pgsql-admin@postgresql.org)=0ATo make changes to you= r subscription:=0Ahttp://www.postgresql.org/mailpref/pgsql-admin=0A=0A=0A= =0A Veja quais s=C3=A3o os assuntos do momento no Yahoo! +Buscados=0Ah= ttp://br.maisbuscados.yahoo.com --0-192846743-1232559854=:25662 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
The size of object depend on report  for a user requ= est,
shared_buffers =3D 2048MB
work_mem =3D 12MB

-------
S= erver 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 bigg= er , hangs .
No able to select or others report in this table.

 





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

pa= ulo matadr wrote:
> I everyone, need help!!!
> My aplication re= turn erro:
>
> 2009-01-20 10:22:03,264 INFO  [STDOUT] Cau= sed by: org.postgresql.util.
> PSQLException: ERROR: invalid memory a= lloc request size 1705447581
>
>
>  TABLE batch.re= latorio_gerado
>
>  rege_id integer NOT NULL,
>&n= bsp; fuin_id integer NOT NULL,
>  rela_id integer NOT NULL,>  rege_tmultimaalteracao timestamp without time zone NOT NULL DE= FAULT 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 do= ing in terms of SQL?
INSERT, UPDATE, DELETE?

How big are the bina= ry objects involved?

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

Yours,
Laurenz Albe

--
Se= nt via pgsql-admin mailing list (pgsql-admin@postgresql.or= g)
To make changes to your subscription:
http://www.postgresql.= org/mailpref/pgsql-admin

=0A=0A=0A
Veja quais s=C3=A3o os assuntos do momento no Yahoo! + Buscados: Top 10 - Celebridades - M=C3=BAsica - Esportes<= /body> --0-192846743-1232559854=:25662--