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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-hackers by date

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