X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id CC2023A56B5 for ; Fri, 3 Dec 2004 12:19:59 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 63248-03 for ; Fri, 3 Dec 2004 12:19:30 +0000 (GMT) Received: from mail2.atl.registeredsite.com (mail2.atl.registeredsite.com [64.224.219.76]) by svr1.postgresql.org (Postfix) with ESMTP id 2765E3A4F77 for ; Fri, 3 Dec 2004 12:19:32 +0000 (GMT) Received: from pixelart.es (pixelart.es [216.122.189.118] (may be forged)) by mail2.atl.registeredsite.com (8.12.11/8.12.8) with ESMTP id iB3CJWmr012838 for ; Fri, 3 Dec 2004 12:19:32 GMT Received: from mj (224.Red-80-32-232.pooles.rima-tde.net [80.32.232.224]) by pixelart.es (8.8.7/8.8.5) with ESMTP id EAA25768 for ; Fri, 3 Dec 2004 04:19:31 -0800 (PST) From: =?iso-8859-1?Q?M=AA_Jos=E9_Sempere?= To: Subject: binary tipes Date: Fri, 3 Dec 2004 13:18:43 +0100 Organization: Pixelart S.L. Message-ID: <000301c4d932$3c02dfb0$0900a8c0@mj> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.4510 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 Importance: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.026 tagged_above=0 required=5 tests=RCVD_IN_NJABL_PROXY X-Spam-Level: * X-Archive-Number: 200412/32 X-Sequence-Number: 15618 Hello We're searching information about binary type fields. We've found two possible types: bytea and blob. We've created a table with a bytea type field. We'd like having no more than one row with identical content In that field. So, we've declared a unique index on that field. We'd like to know if in tables with a lot of rows the existence of that index will slow the insertion of new rows (perhaps because before inserting it must compare that field with the content of the same bytea field For all the existing rows in the table). We'd also like to know how does PostgreSql implement that comparation Between bytea fields (if it compares all the content of the field, Or if that comparation is improved with any algorithm, as CRC, Or anything else). If anybody has experience in that kind of problems, we'd thank very much its help. Greetings for everybody