Re: Big array speed issues - Mailing list pgsql-performance

From Merlin Moncure
Subject Re: Big array speed issues
Date
Msg-id b42b73150606211249w34e7b750t3cd1b7682c39497e@mail.gmail.com
Whole thread Raw
In response to Re: Big array speed issues  ("Merkel Marcel (CR/AEM4)" <Marcel.Merkel@de.bosch.com>)
List 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 by date:

Previous
From: "jody brownell"
Date:
Subject: Re: Help tuning autovacuum - seeing lots of relationbloat
Next
From: Tom Lane
Date:
Subject: Re: Performance of DOMAINs