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 BF5EDD1B486 for ; Wed, 3 Dec 2003 22:32:49 +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 19449-01 for ; Wed, 3 Dec 2003 18:32:20 -0400 (AST) Received: from bramble.mmrd.com (unknown [65.217.53.66]) by svr1.postgresql.org (Postfix) with ESMTP id 6D3D6D1B479 for ; Wed, 3 Dec 2003 18:32:17 -0400 (AST) Received: from thorn.mmrd.com (thorn.mmrd.com [172.25.10.100]) by bramble.mmrd.com (8.12.8/8.12.8) with ESMTP id hB3Lg7cM016428 for ; Wed, 3 Dec 2003 16:42:07 -0500 Received: from gnvex001.mmrd.com (gnvex001.mmrd.com [192.168.3.55]) by thorn.mmrd.com (8.11.6/8.11.6) with ESMTP id hB3MWJl14844 for ; Wed, 3 Dec 2003 17:32:19 -0500 Received: from camel.mmrd.com ([172.25.5.213]) by gnvex001.mmrd.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2657.72) id XT87Z8D2; Wed, 3 Dec 2003 17:32:16 -0500 Subject: sequence overhead From: Robert Treat To: pgsql-performance@postgresql.org Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 Date: 03 Dec 2003 17:32:18 -0500 Message-Id: <1070490739.25244.10530.camel@camel> Mime-Version: 1.0 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/58 X-Sequence-Number: 4918 Just wondering if anyone has done any testing on the amount of overhead for insert you might gain by adding a serial column to a table. I'm thinking of adding a few to some tables that get an average of 30 - 40 inserts per second, sometimes bursting over 100 inserts per second and wondering if there will be any noticeable impact. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL