Re: Big array speed issues

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: Big array speed issues
Дата
Msg-id b42b73150606211249w34e7b750t3cd1b7682c39497e@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Big array speed issues  ("Merkel Marcel (CR/AEM4)" <Marcel.Merkel@de.bosch.com>)
Список pgsql-performance
> Not yet. I would first like to know what is the time consuming part and
> what is a work around. If you are sure individual columns for every
> entry of the array solve the issue I will joyfully implement it. The
> downsize of this approch is that the array dimensions are not always the
> same in my scenario. But I have a workaround in mind for this issue.

The first thing I would try would be to completely normalize te file, aka

create table data as
(
  id int,
  t timestamp,
  map_x int,
  map_y int,
  value float
);

and go with denormalized approach only when this doesn't work for some reason.

merlin

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

Предыдущее
От: "jody brownell"
Дата:
Сообщение: Re: Help tuning autovacuum - seeing lots of relationbloat
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Performance of DOMAINs