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

2007-07-25 Thread Gregory Stark
"Simon Riggs" <[EMAIL PROTECTED]> writes: > On Wed, 2007-07-25 at 10:09 -0400, Merlin Moncure wrote: >> >> 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. > > An

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

2007-07-25 Thread Simon Riggs
On Wed, 2007-07-25 at 10:09 -0400, Merlin Moncure wrote: > On 7/25/07, Simon Riggs <[EMAIL PROTECTED]> wrote: > > > > 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( co

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

2007-07-25 Thread Merlin Moncure
On 7/25/07, Simon Riggs <[EMAIL PROTECTED]> 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

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

2007-07-25 Thread Simon Riggs
On Wed, 2007-07-25 at 15:07 +0200, Mario Weilguni wrote: > Am Mittwoch 25 Juli 2007 schrieb Simon Riggs: > > I have reasonable evidence that Referential Integrity is the major > > performance bottleneck and would like some objective evidence that this > > is the case. > > Just curious, will 8.3 st

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

2007-07-25 Thread Mario Weilguni
Am Mittwoch 25 Juli 2007 schrieb Simon Riggs: > I have reasonable evidence that Referential Integrity is the major > performance bottleneck and would like some objective evidence that this > is the case. Just curious, will 8.3 still check FK constraints (and use locks) even if the referencing col

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

2007-07-25 Thread Simon Riggs
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 > > compl

Re: [PERFORM] 8.2 -> 8.3 performance numbers

2007-07-24 Thread Merlin Moncure
On 7/20/07, Josh Berkus <[EMAIL PROTECTED]> 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 n

Re: [PERFORM] 8.2 -> 8.3 performance numbers

2007-07-20 Thread Jim Nasby
On Jul 20, 2007, at 1:03 PM, 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 number

Re: [PERFORM] 8.2 -> 8.3 performance numbers

2007-07-20 Thread Josh Berkus
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 benchma

[PERFORM] 8.2 -> 8.3 performance numbers

2007-07-19 Thread Jim Nasby
Sorry for the cross-post, but this is performance and advocacy related... 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 comp