Re: Is this good spec for a PostgreSQL server? - Mailing list pgsql-general

From Bjørn T Johansen
Subject Re: Is this good spec for a PostgreSQL server?
Date
Msg-id 20070919153239.24a7c8ab@laptop-btj
Whole thread Raw
In response to Re: Is this good spec for a PostgreSQL server?  (Ron Johnson <ron.l.johnson@cox.net>)
Responses Re: Is this good spec for a PostgreSQL server?
Re: Is this good spec for a PostgreSQL server?
List pgsql-general
On Wed, 19 Sep 2007 07:59:36 -0500
Ron Johnson <ron.l.johnson@cox.net> wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On 09/19/07 07:33, Bjørn T Johansen wrote:
> > Well, it isn't really the largest database or the database that
> > need the most performance... At the moment, the database isn't
> > larger than 15MB and is growing slowly... It is a webapp that is
>
> That'll fit in shared memory.  Very fast.
>
> Where will it be in a year?

Well, twice as much I guess...

>
> > using the database and at the most (at the moment) there is about
> > 12-14 concurrent users and not much data volume...
>
> How many users in a year?

It's an internal webapp for a company, so I guess not that much more...

>
> > We are thinking about this spec. because the web app is a java
> > app, and we need need something that can run java fast as well as
> > postgresql...
>
> 12-14 users on a Quad-core system with 4GB RAM?
>
> Am I so old that (even accepting Tomcat and Java) that seems
> "excessive"?

Yes, I think that it's a bit excessive but the company can afford it so why not... :)


BTJ

pgsql-general by date:

Previous
From: Patricia Rodriguez Tome
Date:
Subject: problemes pga_hba.conf
Next
From: Patricia Rodriguez Tome
Date:
Subject: a problem with pg_hba.conf