pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
binary tipes
2+ messages / 2 participants
[nested] [flat]

* binary tipes
@ 2004-12-03 12:18  Mª José Sempere <mjose@pixelart.es>
  0 siblings, 1 reply; 2+ messages in thread

From: Mª José Sempere @ 2004-12-03 12:18 UTC (permalink / raw)
  To: 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






^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: binary tipes
@ 2004-12-03 13:01  Peter Eisentraut <peter_e@gmx.net>
  parent: Mª José Sempere <mjose@pixelart.es>
  0 siblings, 0 replies; 2+ messages in thread

From: Peter Eisentraut @ 2004-12-03 13:01 UTC (permalink / raw)
  To: Mª José Sempere <mjose@pixelart.es>; +Cc: 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

Yes.

> (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,

Yes.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2004-12-03 13:01 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-12-03 12:18 binary tipes Mª José Sempere <mjose@pixelart.es>
2004-12-03 13:01 ` Peter Eisentraut <peter_e@gmx.net>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox