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 BE29C9FA42B;
	Tue,  9 May 2006 13:29:33 -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 88871-04-2; Tue,  9 May 2006 13:29:27 -0300 (ADT)
X-Greylist: delayed 00:25:58.612776 by SQLgrey-
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159])
	by postgresql.org (Postfix) with ESMTP id 1ED1B9F931E;
	Tue,  9 May 2006 13:29:26 -0300 (ADT)
Received: from a.mail.sonic.net (a.mail.sonic.net [64.142.16.245])
	by svr4.postgresql.org (Postfix) with ESMTP id 02E4E5B0653;
	Tue,  9 May 2006 15:58:12 +0000 (GMT)
Received: from [10.1.1.1] (69-12-140-204.dsl.static.sonic.net [69.12.140.204])
	(authenticated bits=0)
	by a.mail.sonic.net (8.13.6/8.13.3) with ESMTP id k49Fw6lZ001806
	(version=TLSv1/SSLv3 cipher=RC4-MD5 bits=128 verify=NO);
	Tue, 9 May 2006 08:58:07 -0700
Subject: Re: [HACKERS] Big IN() clauses etc : feature proposal
From: Mitchell Skinner <mitch@arctur.us>
To: PFC <lists@peufeu.com>
Cc: pgsql-performance@postgresql.org, pgsql-hackers@postgresql.org
In-Reply-To: <op.s897j60qcigqcu@apollo13>
References: <445F7FF8.6070707@comcast.net>
	<1147110142.32369.7.camel@archimedes>
	<20060508175013.GY99570@pervasive.com> <28288.1147111196@sss.pgh.pa.us>
	<op.s89zl30wcigqcu@apollo13>
	<20060509105214.P90693@vesihiisi.cksoft.de>
	<op.s8916gm6cigqcu@apollo13>
	<20060509113337.M90693@vesihiisi.cksoft.de>
	<op.s893vzcpcigqcu@apollo13> <20060509103632.GD29652@svana.org>
	<op.s897j60qcigqcu@apollo13>
Content-Type: text/plain
Date: Tue, 09 May 2006 08:58:05 -0700
Message-Id: <1147190285.32304.43.camel@firebolt>
Mime-Version: 1.0
X-Mailer: Evolution 2.2.3 (2.2.3-2.fc4) 
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200605/213
X-Sequence-Number: 19000

On Tue, 2006-05-09 at 13:29 +0200, PFC wrote:
> 0.101 ms BEGIN
> 1.451 ms CREATE TEMPORARY TABLE tmp ( a INTEGER NOT NULL, b INTEGER NOT  
> NULL, c TIMESTAMP NOT NULL, d INTEGER NOT NULL ) ON COMMIT DROP
> 0.450 ms INSERT INTO tmp SELECT * FROM bookmarks ORDER BY annonce_id DESC  
> LIMIT 20
> 0.443 ms ANALYZE tmp
> 0.365 ms SELECT * FROM tmp
> 0.310 ms DROP TABLE tmp
> 32.918 ms COMMIT

Does the time for commit change much if you leave out the analyze?