From: | "Roderick A(dot) Anderson" <raanders(at)tincan(dot)org> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Row Limit? |
Date: | 2001-11-27 13:28:59 |
Message-ID: | Pine.LNX.4.10.10111270522480.17787-100000@tincan.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mon, 26 Nov 2001, Tom Lane wrote:
> > I'm in the process of convincing a developer to not use MySQL for a web
> > based application. While trolling around several sites I noticed the
> > 1600 attributes (columns) limit of PostgreSQL. Now I can't even begin
> > to think of an application that would need that many I can see the MySQL
> > inclined comparing it to their 2945.
>
> Of course, the real bottom line is that if you think you need more than
> order-of-a-hundred columns, your database design probably needs revision
> anyway ;-)
I agree. I've seen a few tens (ie. 20+) of column tables but they were
de-normalized because of performance issues and the distributed nature
of the database (Oracle). (I think a couple of them were due to
laziness. :-)
Thanks for the clarification.
Cheers,
Rod
--
Let Accuracy Triumph Over Victory
Zetetic Institute
"David's Sling"
Marc Stiegler
From | Date | Subject | |
---|---|---|---|
Next Message | Antonio Sergio de Mello e Souza | 2001-11-27 14:37:20 | Re: Pl/Pgsql triger procedure calls with parameters |
Previous Message | Martijn van Oosterhout | 2001-11-27 12:46:19 | Re: psql timeout |