Re: How many fields in a table are too many - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: How many fields in a table are too many
Date
Msg-id 20030626072819.GD26472@svana.org
Whole thread Raw
In response to Re: How many fields in a table are too many  (<btober@seaworthysys.com>)
Responses Re: How many fields in a table are too many  (<btober@seaworthysys.com>)
Re: How many fields in a table are too many  (Jonathan Bartlett <johnnyb@eskimo.com>)
List pgsql-general
On Thu, Jun 26, 2003 at 03:17:12AM -0400, btober@seaworthysys.com wrote:
> > I have a table with 13 fields. Is that
> > too many fields for one table.
> > Mark
> >
>
> Thirteen? No way. I've got you beat with 21:

Pfft! Is *that* all?  I've got a table with 116 fields. Very soon we'll be
upgrading to 7.3 and we can them merrily DROP COLUMN half of them. Until
then...

The original developers didn't really have a concept of storing different
info in different tables.
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> "the West won the world not by the superiority of its ideas or values or
> religion but rather by its superiority in applying organized violence.
> Westerners often forget this fact, non-Westerners never do."
>   - Samuel P. Huntington

Attachment

pgsql-general by date:

Previous
From: "Kallol Nandi"
Date:
Subject: Re: How many fields in a table are too many
Next
From: Peter Childs
Date:
Subject: Re: Question regarding performance (large objects involved)