"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
1. Postgres version 22.214.171.124 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.
> Laurenz Albe
In response to
pgsql-jdbc by date
|Next:||From: Thomas Finneid||Date: 2009-06-23 06:28:42|
|Subject: query priorities?|
|Previous:||From: Heikki Linnakangas||Date: 2009-06-22 09:53:40|
|Subject: Re: prepared transaction with identifier "1197822575_XAAAAAAAAABHVE1JRAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA==_AQAAAAAAAABHVE1JRAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=="
does not ex|