X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id DAB2ED1B432; Mon, 26 Apr 2004 13:38:04 -0300 (ADT) 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 21040-06; Mon, 26 Apr 2004 13:38:01 -0300 (ADT) Received: from FE-mail03.sfg.albacom.net (FE-mail03.albacom.net [213.217.149.83]) by svr1.postgresql.org (Postfix) with ESMTP id 903E5D1B4E6; Mon, 26 Apr 2004 13:38:00 -0300 (ADT) Received: from axa.it (217.221.80.72) by FE-mail03.sfg.albacom.net (7.0.009) id 40757CA500244891; Mon, 26 Apr 2004 18:37:56 +0200 Message-ID: <408D3AE8.5020006@axa.it> Date: Mon, 26 Apr 2004 18:38:00 +0200 From: Edoardo Ceccarelli User-Agent: Mozilla Thunderbird 0.5 (Windows/20040207) X-Accept-Language: it, en, en-us MIME-Version: 1.0 To: pgsql-jdbc@postgresql.org, pgsql-performance@postgresql.org, pgsql-admin@postgresql.org Subject: is a good practice to create an index on the oid? Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200404/313 X-Sequence-Number: 13286 I am using the oid of the table as the main key and I've found that is not indexed (maybe because I have declared another primary key in the table) it is a good practice to create an index like this on the oid of a table? CREATE INDEX idoid annuncio400 USING btree (oid); does it work as a normal index? Thank you Edoardo