Effect of too many columns

Поиск
Список
Период
Сортировка
От Rajesh Kumar Mallah
Тема Effect of too many columns
Дата
Msg-id 407A8369.9090205@trade-india.com
обсуждение исходный текст
Ответы Re: Effect of too many columns  (Bruno Wolff III <bruno@wolff.to>)
Список pgsql-performance
Greetings,

Is there any performance penalty of having too many columns in
a table in terms of read and write speeds.

To order to keep operational queries simple (avoid joins) we plan to
add columns in the main customer dimension table.

Adding more columns also means increase in concurrency in the table
as more and more applications will access the same table.

Any ideas if its better to split the table application wise or is it ok?



Regds
mallah.

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

Предыдущее
От: Pailloncy Jean-Gérard
Дата:
Сообщение: Index Backward Scan fast / Index Scan slow !
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: Effect of too many columns