Re: [PERFORM] Intermitent slow queries

2007-05-03 Thread Ron
sday, May 02, 2007 2:55 PM To: Parks, Aaron B. Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] Intermitent slow queries Among other possibilities, there's a known problem with slow memory leaks in various JVM's under circumstances similar to those you are describing. The behavior y

Re: [PERFORM] Intermitent slow queries

2007-05-02 Thread Parks, Aaron B.
55 PM To: Parks, Aaron B. Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] Intermitent slow queries Among other possibilities, there's a known problem with slow memory leaks in various JVM's under circumstances similar to those you are describing. The behavior you are desc

Re: [PERFORM] Intermitent slow queries

2007-05-02 Thread Parks, Aaron B.
ay, May 02, 2007 2:18 PM To: Parks, Aaron B. Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] Intermitent slow queries On 2-May-07, at 11:24 AM, Parks, Aaron B. wrote: My pg 8.1 install on an AMD-64 box (4 processors) with 9 gigs of ram running RHEL4 is acting kind of odd and I

Re: [PERFORM] Intermitent slow queries

2007-05-02 Thread Steinar H. Gunderson
On Wed, May 02, 2007 at 02:55:26PM -0400, Ron wrote: > The fastest test, and possible fix, is to go and buy more RAM. See > if 16MB of RAM, heck even 10MB, makes the problem go away or delays > it's onset. Something tells me 16MB of RAM is not going to help him much? :-) /* Steinar */ -- Home

Re: [PERFORM] Intermitent slow queries

2007-05-02 Thread Ron
Among other possibilities, there's a known problem with slow memory leaks in various JVM's under circumstances similar to those you are describing. The behavior you are describing is typical of this scenario. The increasing delay is caused by longer and longer JVM garbage collection runs as jav

Re: [PERFORM] Intermitent slow queries

2007-05-02 Thread Dave Cramer
On 2-May-07, at 11:24 AM, Parks, Aaron B. wrote: My pg 8.1 install on an AMD-64 box (4 processors) with 9 gigs of ram running RHEL4 is acting kind of odd and I thought I would see if anybody has any hints. I have Java program using postgresql-8.1-409.jdbc3.jar to connect over the netwo

[PERFORM] Intermitent slow queries

2007-05-02 Thread Parks, Aaron B.
My pg 8.1 install on an AMD-64 box (4 processors) with 9 gigs of ram running RHEL4 is acting kind of odd and I thought I would see if anybody has any hints. I have Java program using postgresql-8.1-409.jdbc3.jar to connect over the network. In general it works very well. I have run batch upda