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

Re: Slow PL/pgSQL 8.0.RC5 (7.4.6. 3times faster)

From: Mark Kirkwood <markir(at)coretech(dot)co(dot)nz>
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>,Pavel Stehule <stehule(at)kix(dot)fsv(dot)cvut(dot)cz>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Slow PL/pgSQL 8.0.RC5 (7.4.6. 3times faster)
Date: 2005-01-13 23:58:43
Message-ID: 41E70B33.1090400@coretech.co.nz (view raw or flat)
Thread:
Lists: 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


In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2005-01-14 00:32:38
Subject: Re: Bug? 8.0 does not use partial index
Previous:From: WesDate: 2005-01-13 23:55:14
Subject: Re: [HACKERS] Much Ado About COUNT(*)

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