users table and user_details table? Bad form?

From: plu tard <plutard12(at)hotmail(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: users table and user_details table? Bad form?
Date: 2007-11-28 06:37:25
Message-ID: BAY108-W5986A92CFB3445910A1B5A6770@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I have a users table that's getting pretty large (~ 2M rows) and that's
very sparse, because most users register but don't do much, so a lot
of the columns are NULL.

I'm thinking of adding a user_details table with a unique foreign key
constraint to the users table, and moving all those rarely populated
columns into it. A row in user_details would only be created it we need
to populate one or more of the columns in there.

Is that an okay idea?

It doesn't violate any normalization rules, does it?
And in practice, does it cause any problems?

Thanks.

_________________________________________________________________
You keep typing, we keep giving. Download Messenger and join the i’m Initiative now.
http://im.live.com/messenger/im/home/?source=TAGLM

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Sean Davis 2007-11-28 12:42:46 Re: users table and user_details table? Bad form?
Previous Message Григорий Никоноров 2007-11-27 18:31:39 Re: psql: FATAL: Ident authentication failed for user "jira"