Re: How to store clickmap points? - Mailing list pgsql-general

I finally store points in structure with arrays, and pack it once at day.

create type t_point as (
  x smallint,
  y smallint,
  hits integer
);

CREATE TABLE clickmap (
  page_id integer,
  date date,
  points  t_point[]
);

This method save 6x more space than previous

Thanks for all!








--
View this message in context:
http://postgresql.1045698.n5.nabble.com/How-to-store-clickmap-points-tp5739121p5740725.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.