Franck Routier wrote:
Le lundi 30 juin 2008 à 13:24 -0700, Mark Roberts a écrit :
Hi Mark,
Is there any particular reason that you're not using a surrogate key?
Well, human readability is the main reason, no standard way to handle
sequences between databases vendors being the second... (and
Le lundi 30 juin 2008 à 13:24 -0700, Mark Roberts a écrit :
Hi Mark,
> Is there any particular reason that you're not using a surrogate key?
Well, human readability is the main reason, no standard way to handle
sequences between databases vendors being the second... (and also
problems when copyi
On Mon, 2008-06-30 at 18:57 +0200, Franck Routier wrote:
> Hi,
>
> I have problems with my database becoming huge in size (around 150 GB
> right now, and 2/3 for only three tables, each having around 30 millions
> tuples. Space is spent mainly on indices.).
>
> I have a lot of multi-column varch
Hi,
I have problems with my database becoming huge in size (around 150 GB
right now, and 2/3 for only three tables, each having around 30 millions
tuples. Space is spent mainly on indices.).
I have a lot of multi-column varchar primary keys (natural keys), and
lot of foreign keys on these tables
