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

Re: Queries very slow and memory consumption too high

From: Saurabh Dave <saurabhdave(at)gmail(dot)com>
To: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Queries very slow and memory consumption too high
Date: 2009-06-23 01:48:05
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc
Thanks Albe,

"You'll have to analyze *what* is slow."

That is an excellent question, which I am struggling to answer.
As per your recommendation I moved DB Server on a remote machine and made
following changes:
1. Postgres version instead of 8.2
2. DB encoding changed from UTF-8 to SQL_ANSCII

Now I see the performance of my application to be quite fast, I need to
observe it for some more time though.

But over the top, do you think that changing the encoding would make


On Mon, Jun 22, 2009 at 1:02 PM, Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>wrote:

> Saurabh Dave wrote:
> > 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.
> You'll have to analyze *what* is slow.
> Is it the database server or some other component?
> It helps to have the various components installed on different machines.
> Once you have found out what is slow, drill down there.
> If it turns out to be the database and need help, you'll have to provide
> EXPLAIN ANALYZE output of a sample query that runs fast in the
> beginning and slow later.
> Yours,
> Laurenz Albe

In response to


pgsql-jdbc by date

Next:From: Thomas FinneidDate: 2009-06-23 06:28:42
Subject: query priorities?
Previous:From: Heikki LinnakangasDate: 2009-06-22 09:53:40

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