X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id DA9CBD1D47A for ; Mon, 1 Dec 2003 13:02:21 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 96749-03 for ; Mon, 1 Dec 2003 09:01:53 -0400 (AST) Received: from mailout02.sul.t-online.com (mailout02.sul.t-online.com [194.25.134.17]) by svr1.postgresql.org (Postfix) with ESMTP id C0256D1C526 for ; Mon, 1 Dec 2003 09:01:49 -0400 (AST) Received: from fwd09.aul.t-online.de by mailout02.sul.t-online.com with smtp id 1AQngV-0001ZW-09; Mon, 01 Dec 2003 14:01:51 +0100 Received: from router.azrael.de (rPrT4+Z1oeP6G5n6d-8sO+R3M5AcCy9RHbb3u+fHd1wyh19Ib0mScg@[80.141.228.135]) by fmrl09.sul.t-online.com with esmtp id 1AQngB-0lzJB20; Mon, 1 Dec 2003 14:01:31 +0100 Received: from azrael.azrael.de (azrael.azrael.de [192.168.202.18]) by router.azrael.de (8.11.4/8.11.4) with ESMTP id hB1D1Lr09223 for ; Mon, 1 Dec 2003 14:01:22 +0100 Date: Mon, 1 Dec 2003 14:01:42 +0100 From: Evil Azrael Reply-To: Evil Azrael X-Priority: 3 (Normal) Message-ID: <1024180491.20031201140142@evilazrael.ath.cx> To: pgsql-performance@postgresql.org Subject: Various Questions MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Seen: false X-ID: rPrT4+Z1oeP6G5n6d-8sO+R3M5AcCy9RHbb3u+fHd1wyh19Ib0mScg@t-dialin.net X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/16 X-Sequence-Number: 4876 Hi! I have 4 question which probably someone can answer. 1) I have a transaction during which no data was modified, does it make a difference whether i send COMMIT or ROLLBACK? The effect is the same, but whatīs about the speed? 2) Is there any general rule when the GEQO will start using an index? Does he consider the number of tuples in the table or the number of data pages? Or is it even more complex even if you donīt tweak the cost setting for the GEQO? 3) Makes it sense to add a index to a table used for logging? I mean the table can grow rather large due to many INSERTs, but is also seldom queried. Does the index slowdown noticable INSERTs? 4) Temporary tables will always be rather slow as they canīt gain from ANALYZE runs, correct? Thanx in advance for any answer Christoph Nelles -- Mit freundlichen Grüssen Evil Azrael mailto:root@evilazrael.ath.cx