Postgres Pro
Downloads
Home   >   mailing lists

Using enum instead of join tables - Mailing list pgsql-general

From hmidi slim
Subject Using enum instead of join tables
Date
Msg-id CAMsqVxsmpWTqzCrL2PP2G4-6dCSUF3PjroRYLmAeF9tGFWjCHA@mail.gmail.com
Whole thread Raw
Responses Re: Using enum instead of join tables
List pgsql-general
Tree view
Hi,
Is it a good thing to use enum type such a column in a table instead of making a foreign key which references to another table?
I found these links talking about enum and when I will use them:
http://komlenic.com/244/8-reasons-why-mysqls-enum-data-type-is-evil/
https://www.percona.com/blog/2008/01/24/enum-fields-vs-varchar-vs-int-joined-table-what-is-faster/

Is there any advices or new updates to use enum type in order to decrease the number of join between the table and optimize the performance and query runtime?

pgsql-general by date:

Previous
From: Hans Schou
Date:
Subject: Grant to a group defined in Windows AD
Next
From: Pavan Deolasee
Date:
Subject: Re: ERROR: unexpected chunk number 0 (expected 1) for toast value76753264 in pg_toast_10920100