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)
|
| Список | 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 по дате отправления: