Re: 8.3RC2 vs 8.2.6 testing results

From: Vlad <marchenko(at)gmail(dot)com>
To: Clodoaldo <clodoaldo(dot)pinto(dot)neto(at)gmail(dot)com>
Cc: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org
Subject: Re: 8.3RC2 vs 8.2.6 testing results
Date: 2008-01-29 18:17:47
Message-ID: cd70c6810801291017pcea4e1eoc3a02c7d1dd23bae@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

More test results for public. We ran my original query and found out
that on 4 cores CPU:

1 thread test 8.2 bits 8.3 by 10..15%
4 threads 8.2. wins 8.3 by ~2%
8 threads 8.3 finally wins 8.2 by ~2%

the same data set was affected during multi-threaded runs, but it's
100% cached from the disk. I guess we see the result of concurrent
scans optimization in 8.3...

--
Vlad

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Geoffrey 2008-01-29 18:28:13 Re: OT - pg perl DBI question
Previous Message Joshua D. Drake 2008-01-29 18:16:44 Re: postgresql book - practical or something newer?