Re: Inserts or Updates

Поиск
Список
Период
Сортировка
От Frank Lanitz
Тема Re: Inserts or Updates
Дата
Msg-id 4F3804F9.4080607@frank.uvena.de
обсуждение исходный текст
Ответ на Re: Inserts or Updates  (Ofer Israeli <oferi@checkpoint.com>)
Ответы Re: Inserts or Updates  (Ofer Israeli <oferi@checkpoint.com>)
Список pgsql-performance
Am 12.02.2012 11:48, schrieb Ofer Israeli:
> Frank Lanitz wrote:
>>> Am 07.02.2012 18:40, schrieb Ofer Israeli:
>>>>> Table 1: 46 columns 23 indexes on fields of the following
>>>>> types: INTEGER - 7 TIMESTAMP - 2 VARCHAR - 12 UUID - 2
>>>>>
>>>>> 23 columns 12 indexes on fields of the following types:
>>>>> INTEGER - 3 TIMESTAMP - 1 VARCHAR - 6 UUID - 2
>>>
>>> Are you regularly updating all columns? If not, maybe a good idea
>>> to split the tables so highly updated columns don't effect
>>> complete line.
> We're not always updating all of the columns, but the reason for
> consolidating all the columns into one table is for UI purposes - in
> the past, they had done benchmarks and found the JOINs to be
> extremely slow and so all data was consolidated into one table.

Ah... I see. Maybe you can check whether all of the data are really
needed to fetch with one select but this might end up in tooo much
guessing and based on your feedback you already did this step.

Cheers,
Frank


Вложения

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

Предыдущее
От: Ofer Israeli
Дата:
Сообщение: Re: Inserts or Updates
Следующее
От: Ofer Israeli
Дата:
Сообщение: Re: Inserts or Updates