Maximum columns for optimum performance (fwd)

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Maximum columns for optimum performance (fwd)
Дата
Msg-id Pine.LNX.4.21.0002170026540.1328-100000@localhost.localdomain
обсуждение исходный текст
Ответы Re: [HACKERS] Maximum columns for optimum performance (fwd)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Can anybody comment on this?

-- 
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden

---------- Forwarded message ----------
Date: Wed, 16 Feb 2000 11:16:48 -0600
From: Jude Weaver <exec@shreve.net>
To: Peter Eisentraut <peter_e@gmx.net>
Subject: Maximum columns for optimum performance

One of our tables have 476 columns and only 12 records or rows in it. We are
coding in Java. When we compile and run against this table it is super slow.

Is there a maximum number of columns past which performance suffers? Would we
be better off building several smaller tables with fewer columns instead of
one big table? Does the number of columns in a table affect speed?






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

Предыдущее
От: "Oliver Elphick"
Дата:
Сообщение: Re: [HACKERS] Date/time types: big changeu
Следующее
От: Bruce Momjian
Дата:
Сообщение: psql password prompt