| From: | Rod Taylor <pg(at)rbt(dot)ca> |
|---|---|
| To: | Mark Wong <markw(at)osdl(dot)org> |
| Cc: | PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>, testperf-general(at)pgfoundry(dot)org |
| Subject: | Re: 8.0beta5 results w/ dbt2 |
| Date: | 2004-11-30 16:03:03 |
| Message-ID: | 1101830583.99116.89.camel@home |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Mon, 2004-11-29 at 16:01 -0800, Mark Wong wrote:
> I have some initial results using 8.0beta5 with our OLTP workload.
> Off the bat I see about a 23% improvement in overall throughput. The
> most significant thing I've noticed was in the oprofile report where
> FunctionCall2 and hash_seq_search have moved down the profile a bit.
>
> Also, I have libc with symbols now so we can see what it's doing with
> in the oprofile output.
>
> 8.0beta5 results:
> http://www.osdl.org/projects/dbt2dev/results/dev4-010/199/
> throughput: 4076.97
>
> 8.0beta4 results:
> http://www.osdl.org/projects/dbt2dev/results/dev4-010/191/
> throughput: 3323.07
It appears that WAL archiving (archive_command) is configured in 191 and
disabled (unset) in 199. Perhaps this accounts for some of the
difference?
--
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2004-11-30 16:05:56 | Re: multiline CSV fields |
| Previous Message | Tom Lane | 2004-11-30 15:57:02 | Re: 8.0beta5 results w/ dbt2 |