Re: How to store clickmap points?

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.