Postgres Pro
Downloads
Home   >   mailing lists

Queries very slow and memory consumption too high - Mailing list pgsql-jdbc

From Saurabh Dave
Subject Queries very slow and memory consumption too high
Date
Msg-id fdd0c0f90906212202s68a9e393u654420245e84df31@mail.gmail.com
Whole thread Raw
Responses Re: Queries very slow and memory consumption too high  (Craig Ringer <craig@postnewspapers.com.au>)
Re: Queries very slow and memory consumption too high  (Thomas Kellerer <spam_eater@gmx.net>)
Re: Queries very slow and memory consumption too high  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
List pgsql-jdbc
Tree view
Hi,

I am using Postgres 8.2.10 + Hibernate + c3p0 connection pooling.
For our application we support MySQL + Oracle + MSSQL + Postgres.

With all the other databases our application is working quite fine, but with Postgres after a day queries are becoming extremely slow and it seems to be taking up all the available memory.

Please let me know what could be the issue. I am new to Postgres, so any help would be greatly appreciated.

Thanks,
Saurabh

pgsql-jdbc by date:

Previous
From: BlackMage
Date:
Subject: Re: Inserting Information in PostgreSQL interval
Next
From: Craig Ringer
Date:
Subject: Re: Queries very slow and memory consumption too high