Skip site navigation (1) Skip section navigation (2)

Re: [pgsql-advocacy] 8.2 -> 8.3 performance numbers

From: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
To: "Simon Riggs" <simon(at)2ndquadrant(dot)com>
Cc: "Josh Berkus" <josh(at)agliodbs(dot)com>, "Jim Nasby" <decibel(at)decibel(dot)org>, "postgresql performance list" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: [pgsql-advocacy] 8.2 -> 8.3 performance numbers
Date: 2007-07-25 14:09:50
Message-ID: b42b73150707250709g3a08af06o5d96810a6f1b82d6@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-performance
On 7/25/07, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
> On Fri, 2007-07-20 at 10:03 -0700, Josh Berkus wrote:
> > Jim,
> >
> > > Has anyone benchmarked HEAD against 8.2? I'd like some numbers to use in
> > > my OSCon lightning talk. Numbers for both with and without HOT would be
> > > even better (I know we've got HOT-specific benchmarks, but I want
> > > complete 8.2 -> 8.3 numbers).
> >
> > We've done it on TPCE, which is a hard benchmark for PostgreSQL.  On
> > that it's +9% without HOT and +13% with HOT.  I think SpecJ would show a
> > greater difference, but we're still focussed on benchmarks we can
> > publish (i.e. 8.2.4) right now.
>
> Josh,
>
> Should you get the chance I would appreciate a comparative test for
> TPC-E.
>
> 1. Normal TPC-E  versus
> 2. TPC-E with all FKs against Fixed tables replaced with CHECK( col IN
> (VALUES(x,x,x,...))) constraints on the referencing tables.
>
> I have reasonable evidence that Referential Integrity is the major
> performance bottleneck and would like some objective evidence that this
> is the case.
>
> No rush, since it will be an 8.4 thing to discuss and improve this
> substantially in any of the ways I envisage.

just a small 'me too' here, the RI penalty seems higher than it should
be...especially when the foreign key table is very small, and I can
see how this would impact benchmarks.

merlin

In response to

Responses

pgsql-performance by date

Next:From: Simon RiggsDate: 2007-07-25 14:22:25
Subject: Re: [pgsql-advocacy] 8.2 -> 8.3 performance numbers
Previous:From: Simon RiggsDate: 2007-07-25 14:09:09
Subject: Re: [pgsql-advocacy] 8.2 -> 8.3 performance numbers

pgsql-advocacy by date

Next:From: Simon RiggsDate: 2007-07-25 14:22:25
Subject: Re: [pgsql-advocacy] 8.2 -> 8.3 performance numbers
Previous:From: Simon RiggsDate: 2007-07-25 14:09:09
Subject: Re: [pgsql-advocacy] 8.2 -> 8.3 performance numbers

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group