Re: Avoiding surrogate keys - Mailing list pgsql-general

From John R Pierce
Subject Re: Avoiding surrogate keys
Date
Msg-id 4BDC8BA9.9080604@hogranch.com
Whole thread Raw
In response to Avoiding surrogate keys  (Thom Brown <thombrown@gmail.com>)
Responses Re: Avoiding surrogate keys  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-general
If your 'natural key' is a large text field, I'd have to assume there's
some point at which a surrogate index would be more efficient.  Would
this be above a few dozen characters, or a few 100 characters?   I
wouldn't want a PK based on a multi-K byte text field for a table that
has many 10s or 100s of 1000s of rows, for sure.





pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: PostgreSQL vs. Microsoft SQL server
Next
From: Rich Shepard
Date:
Subject: Re: PostgreSQL vs. Microsoft SQL server