binary tipes

From: Mª José Sempere <mjose(at)pixelart(dot)es>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: binary tipes
Date: 2004-12-03 12:18:43
Message-ID: 000301c4d932$3c02dfb0$0900a8c0@mj
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Eisentraut 2004-12-03 13:01:19 Re: binary tipes
Previous Message Graf László 2004-12-03 11:22:58 grants