one more performance question I cannot test yet :(

Поиск
Список
Период
Сортировка
От Sergei Shelukhin
Тема one more performance question I cannot test yet :(
Дата
Msg-id 1176581624.188553.156250@n59g2000hsh.googlegroups.com
обсуждение исходный текст
Список pgsql-general
Suppose there's a table with two text fields and a lot of int fields.
THe table will be huge, updated constantly, and will be searched by
all of the int fields, whereas text fields will be for display only.

Does it make sense to split it vertically into two tables, one with
ints and one with texts, and join them in queries to make it faster?


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

Предыдущее
От: "Lloyd Mason"
Дата:
Сообщение: Re: Unexplained case insensitive results
Следующее
От: "richyen3@gmail.com"
Дата:
Сообщение: autovacuum vacuums entire database...is this right?