| From: | "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | "paulo matadr *EXTERN*" <saddoness(at)yahoo(dot)com(dot)br>, <pgsql-general(at)postgresql(dot)org>, "admin" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: [GENERAL] bytea size limit? |
| Date: | 2009-01-21 17:03:17 |
| Message-ID: | D960CB61B694CF459DCFB4B0128514C202F76305@exadv11.host.magwien.gv.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jaume Sabater | 2009-01-21 17:30:53 | Re: PostgreSQL monitoring |
| Previous Message | Vladimir Rusinov | 2009-01-21 16:51:10 | Re: PostgreSQL monitoring |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Albe Laurenz | 2009-01-21 17:15:11 | Re: How to find how much postgresql use the memory? |
| Previous Message | Herouth Maoz | 2009-01-21 16:36:13 | Re: Slow update |