Re: Fast insertion indexes: why no developments

Поиск
Список
Период
Сортировка
От Jeremy Harris
Тема Re: Fast insertion indexes: why no developments
Дата
Msg-id 52836058.6030308@wizmail.org
обсуждение исходный текст
Ответ на Re: Fast insertion indexes: why no developments  (Leonardo Francalanci <m_lists@yahoo.it>)
Ответы Re: Fast insertion indexes: why no developments
Список pgsql-hackers
On 13/11/13 09:07, Leonardo Francalanci wrote:
> Problem? having 4 btree indexes on random values (imsi+imei * 2,
> since we have calling and caller) kills the performance in insertion
> after a while.

Surely there's good correlation between IMSI & IMEI, so have a separate
table to translate one to (a group of) the others, and
halve the indexes on your main table?
-- 
Jeremy




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