| From: | "Shridhar Daithankar" <shridhar_daithankar(at)persistent(dot)co(dot)in> |
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Large databases, performance |
| Date: | 2002-10-03 15:50:16 |
| Message-ID: | 3D9CB490.2412.A78039E@localhost |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers pgsql-performance pgsql-sql |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Justin Clift | 2002-10-03 15:51:31 | Re: Anyone want to assist with the translation of the Advocacy |
| Previous Message | Thomas O'Connell | 2002-10-03 15:48:31 | Re: Anyone want to assist with the translation of the Advocacy site? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Justin Clift | 2002-10-03 15:51:31 | Re: Anyone want to assist with the translation of the Advocacy |
| Previous Message | Thomas O'Connell | 2002-10-03 15:48:31 | Re: Anyone want to assist with the translation of the Advocacy site? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shridhar Daithankar | 2002-10-03 15:56:43 | Re: Large databases, performance |
| Previous Message | Charles H. Woloszynski | 2002-10-03 14:26:59 | Re: Large databases, performance |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shridhar Daithankar | 2002-10-03 15:56:43 | Re: Large databases, performance |
| Previous Message | Achilleus Mantzios | 2002-10-03 15:42:51 | Re: epoch to date |