X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id B77129FA43B
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Sat, 27 May 2006 22:12:04 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 15584-02
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Sat, 27 May 2006 22:11:54 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from linda-3.paradise.net.nz (bm-3a.paradise.net.nz
 [203.96.152.182])
	by postgresql.org (Postfix) with ESMTP id B73229F94EA
	for <pgsql-performance@postgresql.org>;
	Sat, 27 May 2006 22:11:54 -0300 (ADT)
Received: from smtp-2.paradise.net.nz
	(tclsnelb1-src-1.paradise.net.nz [203.96.152.172]) by
	linda-3.paradise.net.nz (Paradise.net.nz) with ESMTP id
	<0IZY00KACBBRV6@linda-3.paradise.net.nz> for
	pgsql-performance@postgresql.org; Sun, 28 May 2006 13:11:52 +1200 (NZST)
Received: from [192.168.1.11] (218-101-29-78.dsl.clear.net.nz [218.101.29.78])
	by smtp-2.paradise.net.nz (Postfix) with ESMTP id 891D4128A3F5; Sun,
	28 May 2006 13:11:51 +1200 (NZST)
Date: Sun, 28 May 2006 13:11:47 +1200
From: Mark Kirkwood <markir@paradise.net.nz>
Subject: Re: is it possible to make this faster?
In-reply-to: <29951.1148676286@sss.pgh.pa.us>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Merlin Moncure <mmoncure@gmail.com>,
	Postgresql Performance <pgsql-performance@postgresql.org>
Message-id: <4478F8D3.7040104@paradise.net.nz>
MIME-version: 1.0
Content-type: text/plain; format=flowed; charset=ISO-8859-1
Content-transfer-encoding: 7bit
User-Agent: Thunderbird 1.5 (X11/20060417)
References: <b42b73150605251307id0e7998td4a3693f0d456f88@mail.gmail.com>
	<15919.1148590347@sss.pgh.pa.us> <16119.1148591497@sss.pgh.pa.us>
	<b42b73150605252147h218ec25ci183283334731adbd@mail.gmail.com>
	<25668.1148653358@sss.pgh.pa.us>
	<b42b73150605260956h30a960efl39d75601d5767747@mail.gmail.com>
	<27137.1148663259@sss.pgh.pa.us>
	<b42b73150605261046w78e48f72j5f080db0e4ee5370@mail.gmail.com>
	<27570.1148666115@sss.pgh.pa.us>
	<b42b73150605261240k64f3cf3ej5c2feebbe9c67c89@mail.gmail.com>
	<29951.1148676286@sss.pgh.pa.us>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200605/501
X-Sequence-Number: 19288

Tom Lane wrote:
> "Merlin Moncure" <mmoncure@gmail.com> writes:
>> your time of 150 ms is looking like the slow case on my results.
> 
> Yeah... so what's wrong with my test?  Anyone else care to duplicate
> the test and see what they get?

Using your test [generating c from int(rand(1000))], I get 230 ms using 
5.0.18 on a P3 1000 Mhz (doing optimize table on t made no difference at 
all).

Cheers

Mark