Hi,
I am using postgres 8.1.3 for this. If this has been dealt with later, please
disregard. And this is not a complaint or a request, I am just curious, so I
know how to best construct my queries.
There is a unique index mapping domains to domain_ids.
views_ts specifies a partitioned table,
Ron:
I'm not sure how the JVM would really affect the issue as it is on a
Windows box connecting remotely. As indicated the PG Server itself has
9 gigs of ram and it never goes up above 1.8 total usage.
If the PG driver is doing something funny (IE waiting to send requests)
that's way out past m
Dave:
Thinks for the thought, but I'm not sure how to fix that. I'm going to
increase the shared memory pages to 5K as soon as my latest vacuum
finishes to see if that helps.
AP
From: Dave Cramer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 02, 2007
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
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
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
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