On Sun, 15 May 2011 00:05:13 +0930, Daron Ryan wrote about Duplicated Fields: > I am designing a database that will include at lot of duplicated > data. >Does Postgres perform many optimisations to eliminate duplications of >fields or should I create additional tables to reference myself? http://en.wikipedia.org/wiki/Database_normalization You should do it yourself. It is called "data normalization", and all good database designers have been doing it for decades. -- Regards, Dave [RLU #314465] *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* dwnoon@xxxxxxxxxxxx (David W Noon) *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
Attachment:
signature.asc
Description: PGP signature
