Please don't top post.
paulo matadr wrote:
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
What are you doing in terms of SQL?
INSERT, UPDATE, DELETE?
How big are the
laurenz.a...@wien.gv.at
Para: paulo matadr *EXTERN* saddon...@yahoo.com.br
Cc: GENERAL pgsql-general@postgresql.org; admin pgsql-ad...@postgresql.org
Enviadas: Quinta-feira, 22 de Janeiro de 2009 6:26:26
Assunto: Re: [ADMIN] [GENERAL] bytea size limit?
Please don't top post.
paulo matadr wrote
checkpoints don't have anything to do with it.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Please don't top post.
paulo matadr wrote:
I think identified the problem
lts's check log below:
Query:
SELECTSTATEMENT: select relatorios0_.fuin_id as fuin5_1_,
relatorios0_.rege_id as rege1_1_, relatorios0_.rege_id as r
ege1_624_0_, relatorios0_.rege_tmultimaalteracao as rege2_624_0_,
On Wed, Jan 21, 2009 at 01:55:28PM +, Grzegorz Ja??kiewicz wrote:
there's no real limit (its size is described with 32bit number, and
that's the only limitation here).
But you need to be aware, that content is sent over at once, so memory
is the limit in your case.
On Wed, Jan 21, 2009 at 2:06 PM, Kenneth Marshall k...@rice.edu wrote:
The TOAST implementation however only allows 30-bits for the
size of the TOAST entry which caps the size at 2^30 or 1GB. I
agree that he could very well be limited also by the memory on
his system.
i wasn't aware of that,
On Wed, Jan 21, 2009 at 02:09:01PM +, Grzegorz Ja??kiewicz wrote:
On Wed, Jan 21, 2009 at 2:06 PM, Kenneth Marshall k...@rice.edu wrote:
The TOAST implementation however only allows 30-bits for the
size of the TOAST entry which caps the size at 2^30 or 1GB. I
agree that he could very
you don't have to quote everything :)
I ment, there's nothing on bytea on its doc page, where one would
expect to read it.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Enviadas: Quarta-feira, 21 de Janeiro de 2009 11:06:23
Assunto: Re: [ADMIN] [GENERAL] bytea size limit?
On Wed, Jan 21, 2009 at 01:55:28PM +, Grzegorz Ja??kiewicz wrote:
there's no real limit (its size is described with 32bit number, and
that's the only limitation here).
But you need
On Wed, Jan 21, 2009 at 3:02 PM, paulo matadr saddon...@yahoo.com.br wrote:
My system have very large ram size, so its possible review postgresql.conf ?
all depends on how you access DB, what type of drivers (odbc, libpq, etc, etc).
See, every time you pass a row , they usually have to allocate
On Wed, Jan 21, 2009 at 03:07:13PM +, Grzegorz Ja??kiewicz wrote:
On Wed, Jan 21, 2009 at 3:02 PM, paulo matadr saddon...@yahoo.com.br wrote:
My system have very large ram size, so its possible review postgresql.conf ?
all depends on how you access DB, what type of drivers (odbc, libpq,
, 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
12 matches
Mail list logo