Lists: | pgsql-general |
---|
From: | "Willy-Bas Loos" <willybas(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | performance differences of major versions |
Date: | 2008-01-09 11:17:15 |
Message-ID: | 1dd6057e0801090317wb38266dga2d40877d0d2ccaa@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
Hi,
Are there any benchmarks that compare different major versions of
PostgreSQL?
Cheers,
WBL
From: | "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | "Willy-Bas Loos" <willybas(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: performance differences of major versions |
Date: | 2008-01-09 11:34:43 |
Message-ID: | 162867790801090334l47c312cfrb22eb6aee00b8c62@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
Hello
pgbench test - default configuration
Verze 7.3.15 7.4.13 8.0.8 8.1.4 8.2.beta1 8.3beta1
tps 311 340 334 398 423 585
but pgbench is simple test and thise numbers hasnot great value.
Regards
Pavel
On 09/01/2008, Willy-Bas Loos <willybas(at)gmail(dot)com> wrote:
> Hi,
>
> Are there any benchmarks that compare different major versions of
> PostgreSQL?
>
> Cheers,
>
> WBL
>
From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
Cc: | Willy-Bas Loos <willybas(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: performance differences of major versions |
Date: | 2008-01-10 00:09:51 |
Message-ID: | 200801100009.m0A09pN09721@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
Pavel Stehule wrote:
> Hello
>
> pgbench test - default configuration
>
> Verze 7.3.15 7.4.13 8.0.8 8.1.4 8.2.beta1 8.3beta1
> tps 311 340 334 398 423 585
>
> but pgbench is simple test and thise numbers hasnot great value.
Wow, even though it is a single benchmark, I have never seen such a
clear comparison between Postgres versions, and the 8.2->8.3 improvement
is huge, +38% improvement.
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
From: | "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net> |
Cc: | "Willy-Bas Loos" <willybas(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: performance differences of major versions |
Date: | 2008-01-10 08:12:30 |
Message-ID: | 162867790801100012x596e9242hf315a29c7c861278@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
On 10/01/2008, Matthew T. O'Connor <matthew(at)zeut(dot)net> wrote:
> Pavel Stehule wrote:
> > pgbench test - default configuration
> >
> > Verze 7.3.15 7.4.13 8.0.8 8.1.4 8.2.beta1 8.3beta1
> > tps 311 340 334 398 423 585
> >
> > but pgbench is simple test and thise numbers hasnot great value.
>
> Was that the same version of pgbench each time? Or was it the pgbench
> that came with each version? I think pgbench has changed a few times,
> if you are using different versions of pgbench, are these numbers at all
> meaningful?
>
I used 8.3 pgbench. I know some problems with it.
pgbench is only one view (one dimension) on PostgreSQL, nothing less
and nothing more. Some cases can be much faster or equal.
> Matt
>
From: | "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net> |
---|---|
To: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
Cc: | Willy-Bas Loos <willybas(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: performance differences of major versions |
Date: | 2008-01-10 13:16:31 |
Message-ID: | 47861AAF.7010200@zeut.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
Pavel Stehule wrote:
> pgbench test - default configuration
>
> Verze 7.3.15 7.4.13 8.0.8 8.1.4 8.2.beta1 8.3beta1
> tps 311 340 334 398 423 585
>
> but pgbench is simple test and thise numbers hasnot great value.
Was that the same version of pgbench each time? Or was it the pgbench
that came with each version? I think pgbench has changed a few times,
if you are using different versions of pgbench, are these numbers at all
meaningful?
Matt
From: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
---|---|
To: | "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> |
Cc: | "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>, "Willy-Bas Loos" <willybas(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: performance differences of major versions |
Date: | 2008-01-10 15:37:07 |
Message-ID: | dcc563d10801100737y71195526kfc733557eb2f0122@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
On Jan 10, 2008 2:12 AM, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> wrote:
> On 10/01/2008, Matthew T. O'Connor <matthew(at)zeut(dot)net> wrote:
> > Pavel Stehule wrote:
> > > pgbench test - default configuration
> > >
> > > Verze 7.3.15 7.4.13 8.0.8 8.1.4 8.2.beta1 8.3beta1
> > > tps 311 340 334 398 423 585
> > >
> > > but pgbench is simple test and thise numbers hasnot great value.
> >
> > Was that the same version of pgbench each time? Or was it the pgbench
> > that came with each version? I think pgbench has changed a few times,
> > if you are using different versions of pgbench, are these numbers at all
> > meaningful?
> >
>
> I used 8.3 pgbench. I know some problems with it.
>
> pgbench is only one view (one dimension) on PostgreSQL, nothing less
> and nothing more. Some cases can be much faster or equal.
While some queries were no faster in 8.2 than in 7.4 for me, there
were many complex reporting queries that were literally thousands of
times faster. Going from minutes (nearly hours) to a second or less.
The real issue, as usual, is "How much faster is version y than
version x for YOU?" And only you can answer that by testing. In
general, I found that complex reporting queries were greatly sped up.
Updates / inserts / deletes were on the order of a bit faster to about
twice as fast.