Re: [ADMIN] Freeing Connections

2001-11-13 Thread Andrew Hill
Apologies for replying to my own post, and resurrecting something from ages ago, but I though that people may be interested in what had happened. You may recall that I was seeing a number of processes like this on my linux PostgreSQL server: [bash] \_ postmaster -i -D/var/pgsql/data -N 32 -B

[ADMIN] PostgreSQL->JDBC->Tomcat->Apache resource uses

2001-11-13 Thread Nick Fankhauser
Hi- It would be great if somebody can give me a "recipe" answer for this, but I'm equally interested in informed conjecture and stories from similar experiences. We're getting ready to spec our hardware for the imminent release of an application which uses JDBC to funnel data from our database t

[ADMIN] Problems on SuSE PPC 7.1

2001-11-13 Thread Thomas Adick
Hello group, maybe someone could help me with following problem: I have installed a SuSE PPC 7.1 on an IBM RS6000 43p PrEP. Thesystem is running fiene. Also I have compiled an own apache. I also installed the PostgreSQL packages. To start the daemon, the command "rcpostgresql start" is needed

[ADMIN] Postgresql optimization

2001-11-13 Thread Peter Darley
Friends, I have what seems to me to be a fairly beefy Linux box (2x1Ghz cpu, 768meg memory) that is a dedicated Postgres server, and which hasn't been performing the way I felt it should. I found a good article on the web about optimizing Postgres on Linux, ( http://www.phpbuilde