Re: Upgrade to dual processor machine?

From: "Shridhar Daithankar" <shridhar_daithankar(at)persistent(dot)co(dot)in>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Upgrade to dual processor machine?
Date: 2002-11-13 11:02:42
Message-ID: 3DD27EAA.29848.517BFB4@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-performance

On 13 Nov 2002 at 11:54, Henrik Steffen wrote:

> Dear Shridhar,
>
> ok, so my system has got 362 MB of free RAM currently... this sounds good.

Cool.. Keep watching that.. If that goes down to less than 50, you certainly
need to look into..

> uname -a says:
> Linux db2.city-map.de 2.4.7-10 #1 Thu Sep 6 17:27:27 EDT 2001 i686 unknown

hmm.. Some sort of RedHat I assume. Upgrade the kernel at least. Any variant of
2.4.19.x should give you at least 10-15% performance increase. Besides that
will cure the linux VM fiascos as well..

> I didn't actually measure requests per minute through a longer period...
> I tested it 2 hours ago using debug and logging all queries, and I saw
> approx. 2500 requests per minute. but at that time of the day there are
> only about 25 simultaneous users on our website. so i calculated 50
> users and 5.000 rpm for average daytime usage. I guess the maximum peak
> would be approx. 10.000 queries per minute.

Hmm.. Certainly connection pooling will give you advantage. Tune it if you can(
php BTW?)

HTH

Bye
Shridhar

--
divorce, n: A change of wife.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shridhar Daithankar 2002-11-13 11:08:53 Re: index question..
Previous Message Williams, Travis L, NPONS 2002-11-13 10:56:31 index question..

Browse pgsql-performance by date

  From Date Subject
Next Message Henrik Steffen 2002-11-13 12:00:18 Re: Upgrade to dual processor machine?
Previous Message Henrik Steffen 2002-11-13 10:54:45 Re: Upgrade to dual processor machine?