Skip site navigation (1) Skip section navigation (2)

Queries very slow and memory consumption too high

From: Saurabh Dave <saurabhdave(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Queries very slow and memory consumption too high
Date: 2009-06-22 05:02:18
Message-ID: fdd0c0f90906212202s68a9e393u654420245e84df31@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
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

Responses

pgsql-jdbc by date

Next:From: Craig RingerDate: 2009-06-22 06:41:15
Subject: Re: Queries very slow and memory consumption too high
Previous:From: BlackMageDate: 2009-06-22 00:27:10
Subject: Re: Inserting Information in PostgreSQL interval

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group