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 NO
On Wed, Jan 21, 2009 at 05:21:03AM -0800, 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
>
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.
http://www.postgresql.org/docs/8.3/static/datatype-binary.html
For such large objects, it might b
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.
>
> http://www.postg
On Wed, Jan 21, 2009 at 2:06 PM, Kenneth Marshall 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, and also
On Wed, Jan 21, 2009 at 02:09:01PM +, Grzegorz Ja??kiewicz wrote:
> On Wed, Jan 21, 2009 at 2:06 PM, Kenneth Marshall 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 b
http://www.postgresql.org/docs/8.3/interactive/using-explain.html
I tried reading that page, but it's still not clear to me, why the index
dbmail_messages_1 is better than dbmail_messages_7:
\d dbmail_messages
Tabelle »public.dbmail_messages«
Spalte |
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-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Michael Monnerie wrote:
> EXPLAIN ANALYZE SELECT 1 FROM dbmail_messages msg JOIN
> dbmail_physmessage pm ON ( pm.id = msg.physmessage_id ) WHERE
> message_idnr BETWEEN 3178782 AND 3616157 AND mailbox_idnr = 3236 AND
> status IN (0,1,2) ORDER BY message_idnr ASC;
[...]
> -> Bitmap H
Deal All,
I have set postgresql.conf for autovacuum and need to know weather the process
is running/working or not.
Regards,
Avdul Rehman.
On Mittwoch 21 Januar 2009 Alvaro Herrera wrote:
> Seems like the problem is that it is not pushing the "status IN"
> condition as part of the index condition for some reason, and instead
> using it as a filter. Maybe something to do with the selectivity of
> that clause?
I was reading your answe
My system have very large ram size, so its possible review postgresql.conf ?
De: Kenneth Marshall
Para: Grzegorz Ja??kiewicz
Cc: paulo matadr ; pgsql-gene...@postgresql.org; admin
Enviadas: Quarta-feira, 21 de Janeiro de 2009 11:06:23
Assunto: Re: [ADMIN] [GEN
On Wed, Jan 21, 2009 at 3:02 PM, paulo matadr 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 that
much memory, not
On Wed, Jan 21, 2009 at 03:07:13PM +, Grzegorz Ja??kiewicz wrote:
> On Wed, Jan 21, 2009 at 3:02 PM, paulo matadr 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).
> S
Abdul Rahman wrote:
> Deal All,
>
> I have set postgresql.conf for autovacuum and need to know weather the
> process is running/working or not.
Run this query:
SHOW autovacuum;
If it says "on", then it is working.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
T
Alvaro Herrera writes:
> Seems like the problem is that it is not pushing the "status IN"
> condition as part of the index condition for some reason, and instead
> using it as a filter. Maybe something to do with the selectivity of
> that clause?
No, AFAIR the planner will *always* include every
On Mittwoch 21 Januar 2009 Tom Lane wrote:
> No, AFAIR the planner will *always* include every possibly relevant
> condition for a given index. If the condition is useless or nearly
> so, that might prompt it to pick a different index instead, but not
> to omit the indexqual. I'm thinking it's no
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Alvaro Herrera schrieb:
> Abdul Rahman wrote:
>> Deal All,
>>
>> I have set postgresql.conf for autovacuum and need to know weather the
>> process is running/working or not.
>
> Run this query:
> SHOW autovacuum;
way easiere than my approach ;-)
Tha
I know I'm pedantic today but I have logs enabled to see every query
done, and those who are called often should be as quick as possible,
where they aren't - and I want to understand why...
Can somebody explain me why on the last line, "dbmail_physmessage",
there is a seq. scan going on and no
On 1/21/09, 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
What exactly were you doing when you got the error?
How big is
Michael Monnerie wrote:
> I know I'm pedantic today but I have logs enabled to see every query
> done, and those who are called often should be as quick as possible,
> where they aren't - and I want to understand why...
What Postgres version is this?
--
Alvaro Herrera
Michael Monnerie writes:
> Can somebody explain me why on the last line, "dbmail_physmessage",
> there is a seq. scan going on and no index used?
Because it chose to use a hash instead. Given the rowcounts I don't
think that's wrong, but if you want to see the other plan you can try
setting ena
On Mon, Jan 19, 2009 at 6:56 PM, Jaume Sabater wrote:
> And I am in the process of writing a bunch of scripts that the Zabbix
> agent will execute to feed the server with information, so that alerts
> and graphs can be produced.
Oh, I have exactly the same in my plans. Where it would possible t
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,
> fu
On Wed, Jan 21, 2009 at 5:51 PM, Vladimir Rusinov
wrote:
>> And I am in the process of writing a bunch of scripts that the Zabbix
>> agent will execute to feed the server with information, so that alerts
>> and graphs can be produced.
>
> Oh, I have exactly the same in my plans. Where it would po
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Vladimir Rusinov a écrit :
> On Mon, Jan 19, 2009 at 6:56 PM, Jaume Sabater wrote:
>
>> And I am in the process of writing a bunch of scripts that the Zabbix
>> agent will execute to feed the server with information, so that alerts
>> and graphs can
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,i
Well, I cleared out other database problems and now I'm back to this
one...
When I run the OpenSSL command below I get the following output...
-bash-3.00$ /usr/local/ssl/bin/openssl verify -CAfile ./root.crt
testcert.pem
Error loading file ./root.crt
24149:error:02001002:system library:fope
They were added in 8.2 by me.
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 512-248-2683E-Mail: l...@lerctr.org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893
-Original Message-
From: pgsql-admin-ow...@postgresql.org
[mailto:pgsql-admin
On Wed, Jan 21, 2009 at 12:50:23PM -0500, Carol Walter wrote:
> -bash-3.00$ /usr/local/ssl/bin/openssl verify -CAfile ./root.crt
> testcert.pem
> Error loading file ./root.crt
> 24149:error:02001002:system library:fopen:No such file or
> directory:bss_file.c:126:fopen('./root.crt','r')
root.crt
On Jan 21, 2009, at 4:24 PM, Ray Stell wrote:
On Wed, Jan 21, 2009 at 12:50:23PM -0500, Carol Walter wrote:
-bash-3.00$ /usr/local/ssl/bin/openssl verify -CAfile ./root.crt
testcert.pem
Error loading file ./root.crt
24149:error:02001002:system library:fopen:No such file or
directory:bss_file.c
On Wed, Jan 21, 2009 at 05:01:08PM -0500, Carol Walter wrote:
>
> On Jan 21, 2009, at 4:24 PM, Ray Stell wrote:
>
>> On Wed, Jan 21, 2009 at 12:50:23PM -0500, Carol Walter wrote:
> Also, in the second part of my message there are lines relating to the
> encryption. I'm not sure what needs to be i
Some of our users use an ODBC connection between MS Access and an Oracle
database to work with the data.
Access however has a 255 field/column limit, which the Oracle Db has now
execeded.
Is there a way to make an ODBC connection between a postgresql db and the
oracle DB and pull all the data f
On Wed, Jan 21, 2009 at 3:31 PM, Marc Fromm wrote:
> Some of our users use an ODBC connection between MS Access and an Oracle
> database to work with the data.
> Access however has a 255 field/column limit, which the Oracle Db has now
> execeded.
I am not sure what kind of data model would requir
On Mittwoch 21 Januar 2009 Alvaro Herrera wrote:
> What Postgres version is this?
8.3 again, the same server as before (openSUSE 11.1)
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key:
On Mittwoch 21 Januar 2009 Alvaro Herrera wrote:
> Seems like the problem is that it is not pushing the "status IN"
> condition as part of the index condition for some reason, and instead
> using it as a filter. Maybe something to do with the selectivity of
> that clause?
I was reading your answe
Hi admins,
I'm running version 8.1.9 of postgres, and using autovacuum, and I'm
worried that I'm heading towards a transaction ID wraparound failure.
autovacuum is running because it is recovering the disk space of updated
rows (of which there are many each second).
But age(datfrozenid) is
37 matches
Mail list logo
