Re: update == delete + insert?

From: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
To: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
Cc: "Jaime Casanova" <systemguards(at)gmail(dot)com>, "Craig A(dot) James" <cjames(at)modgraph-usa(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: update == delete + insert?
Date: 2006-03-21 14:12:08
Message-ID: b42b73150603210612q65eebe9fu4c45698eddd75575@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> > design 1 is normalized and better
> > design 2 is denormalized and a bad approach no matter the RDBMS
>
> How is design 1 denormalized?

It isn't :)...he said it is normalized. Design 2 may or may not be
de-normalized (IMO there is not enough information to make that
determination) but as stated it's a good idea to split the table on
practical grounds.

merlin

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Guillaume Cottenceau 2006-03-21 14:34:48 Re: Postmaster using only 4-5% CPU
Previous Message Markus Bertheau 2006-03-21 14:10:56 Re: Postmaster using only 4-5% CPU