From: Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
To: pgsql-general <pgsql-general@postgresql.org>
Subject: Re: Large databases, performance
Date: Thu, 03 Oct 2002 21:20:16 +0530
Message-ID: <3D9CB490.2412.A78039E@localhost> (raw)
In-Reply-To: <3D9C53B3.2050508@clearmetrix.com>
On 3 Oct 2002 at 10:26, Charles H. Woloszynski wrote:
> Forgive my ignorance, but what about 2.4.19-16 is that much faster? Are
> we talking about 2x improvement for your tests? We are currently on
> 2.4.9 and looking at the performance and wondering... so any comments
> are appreciated.
Well, for one thing, 2.4.19 contains backported O(1) scheduler patch which
improves SMP performance by heaps as task queue is per cpu rather than one per
system. I don't think any system routinely runs thousands of processes unless
it's a web/ftp/mail server. In that case improved scheduling wuld help as
well..
Besides there were major VM rewrites/changes after 2.4.10 which corrected
almost all the major VM fiaskos on linux. For anything VM intensive it's
recommended that you run 2.4.17 at least.
I would say it's worth going for it.
Bye
Shridhar
--
Sturgeon's Law: 90% of everything is crud.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: shridhar_daithankar@persistent.co.in, pgsql-general@postgresql.org
Subject: Re: Large databases, performance
In-Reply-To: <3D9CB490.2412.A78039E@localhost>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox