Re: surrogate vs natural primary keys

From: Seb <spluque(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: surrogate vs natural primary keys
Date: 2008-09-15 22:56:31
Message-ID: 87hc8h2f34.fsf@patagonia.sebmags.homelinux.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Mon, 15 Sep 2008 16:45:08 -0600,
"Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> wrote:

[...]

> I think this question is a lot like "how large should I set
> shared_buffers?" There's lots of different answers based on how you
> are using your data.

Yes, this is precisely what I'm after: *criteria* to help me decide
which approach to take for different scenarios. Such guidance is what
seems to be lacking from most of the discussions I've seen on the
subject. It's hard to distill this information when most of the
discussion is centered on advocating one or the other approach.

Thanks,

--
Seb

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Hengky Lie 2008-09-16 05:01:11 Simple Problem ?
Previous Message Scott Marlowe 2008-09-15 22:45:08 Re: surrogate vs natural primary keys