Re: Persistent connections to database?

["Joshua D. Drake" <..hidden..>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Fri, 16 Nov 2007 18:15:27 -0600
Charley Tiggs <..hidden..> wrote:

> Joshua D. Drake wrote:
> >>> It sounds more like a machine level issue (bad configuration of
> >>> postgresql, not enough IO/RAM etc..)
> >> Josh,

> > How many connections are we talking about at peak? What type of
> > hardware do you have?
> 
> 
> 80 connections at peak.  Before the past two days, it had rarely 
> exceeded 20 connections at peak.
> 
> Dell PowerEdge 860, dual-core Xeon 3.2 GHz, with 2 gig of memory.
> 72GB SCSI hard drives with 1MB disc cache.

How many hard drives, what raid level? I assume you mean 1G of cache?

What does your postgreql.conf look like? Is this a dedicated postgresql
machine or does apache and ledgersmb run on top of it?

What does it say if you connect to template1 and run vacuum verbose
analyze (I need the last 5 lines).

Joshua D. Drake


> 
> Charley
> 


- -- 

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564   24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997  http://www.commandprompt.com/
			UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHPjTOATb/zqfZUUQRAtZKAKCq6Y9znG6k0GyhzFb1p2NUA57uGACfZAQL
bF2Ct6iE/gHhW9us5zQv6Zs=
=rMjm
-----END PGP SIGNATURE-----