From: Shane Ambler <pgsql@Sheeky.Biz>
To: Jean-David Beyer <jeandavid8@verizon.net>
Cc: pgsql-sql@postgresql.org
Subject: Re: Curious about wide tables.
Date: Mon, 28 Apr 2008 01:02:37 +0930
Message-ID: <48149C95.9080706@Sheeky.Biz> (raw)
In-Reply-To: <48147917.8000108@verizon.net>
References: <48147917.8000108@verizon.net>
Jean-David Beyer wrote:
> In another thread, the O.P. had a question about a large table with over 100
> columns. Is this usual? Whenever I make a database, which is not often, it
> ends up with tables that rarely have over to columns, and usually less than
> that. When normalized, my tables rarely get very wide.
>
> Without criticising the O.P., since I know nothing about his application, I
> am curious how it comes about that such a wide table is justified.
>
Depends on the application.
Something like drivers license db will have a few things like name,
address, type, dob, restrictions and end date
Then something like an insurance policy where each record needs to know
who it is for, the item(car - rego make model... house - address suburb
state), effective date, end date, date of inception, type of cover,
value of cover, excess amount, base premium, agent fees, gov fees, total
premium, invoice sent, who entered it and when......
Sometimes you can have a lot of data that makes up one instance.
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: pgsql@Sheeky.Biz, jeandavid8@verizon.net
Subject: Re: Curious about wide tables.
In-Reply-To: <48149C95.9080706@Sheeky.Biz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox