Re: Row Limit?

Поиск
Список
Период
Сортировка
От Roderick A. Anderson
Тема Re: Row Limit?
Дата
Msg-id Pine.LNX.4.10.10111270522480.17787-100000@tincan.org
обсуждение исходный текст
Ответ на Re: Row Limit?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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


В списке pgsql-general по дате отправления:

Предыдущее
От: Mike Harding
Дата:
Сообщение: Re: Strange performance issue
Следующее
От: "Greg Sabino Mullane"
Дата:
Сообщение: Re: Timing a query