Re: Slow PL/pgSQL 8.0.RC5 (7.4.6. 3times faster) - Mailing list pgsql-hackers

From Mark Kirkwood
Subject Re: Slow PL/pgSQL 8.0.RC5 (7.4.6. 3times faster)
Date
Msg-id 41E70B33.1090400@coretech.co.nz
Whole thread Raw
In response to Re: Slow PL/pgSQL 8.0.RC5 (7.4.6. 3times faster)  (Michael Fuhr <mike@fuhr.org>)
Responses Re: Slow PL/pgSQL 8.0.RC5 (7.4.6. 3times faster)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Michael Fuhr wrote:
> On Thu, Jan 13, 2005 at 05:05:00PM -0500, Tom Lane wrote:
> 
> SELECT delitel(1000000, 1);
> 
> Mean times over the last five of six runs on my poor 500MHz FreeBSD
> 4.11-PRERELEASE box:
> 
> 6741 ms   7.4.6 (from FreeBSD ports collection)
> 14427 ms  8.0.0rc5 (from CVS source)
> 
>
> 

Looks like something introduced between RC1 and RC5:

7455 ms   8.0.0RC5
3978 ms   8.0.0RC1
3951 ms   7.4.6

Box is FreeBSD 5.3, all 3 Pg versions built using
./configure --prefix=<prefix> --with-openssl



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Slow PL/pgSQL 8.0.RC5 (7.4.6. 3times faster)
Next
From: Tom Lane
Date:
Subject: Re: Bug? 8.0 does not use partial index