Skip site navigation (1) Skip section navigation (2)

Re: binary tipes

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Mª José Sempere <mjose(at)pixelart(dot)es>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: binary tipes
Date: 2004-12-03 13:01:19
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
Am Freitag, 3. Dezember 2004 13:18 schrieb Mª José Sempere:
> 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).

Not with all rows, since it's a B-tree index, but with some rows for sure.

> We'd also like to know how does PostgreSql implement that comparation
> Between bytea fields (if it compares all the content of the field,


Peter Eisentraut

In response to

  • binary tipes at 2004-12-03 12:18:43 from Mª José Sempere

pgsql-admin by date

Next:From: Tom LaneDate: 2004-12-03 16:13:18
Subject: Re: On disk format postgresql 7.4.3-i386 and x86-64 ?
Previous:From: Mª José SempereDate: 2004-12-03 12:18:43
Subject: binary tipes

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group