Re: How to store clickmap points?

Whatever you did to get 1 million points a day on your site.. I want in..
the name of your marketer please!

I agree with condensing this into a heatmap or a set of RRDs.. one for X..
one for Y.. one for x * (y * max_height)). You can easily query RRDs later
on.. even multiple RRD files at once.

Also.. don't be afraid of flat files. They compress well.

- Shane

On Mon, Jan 14, 2013 at 5:29 AM, aasat <satriani(at)veranet(dot)pl> wrote:

> > Instead of storing x/y, have you considered referencing a region of
> pixels?
> The bigger the region, the larger your possible savings.
>
> Good idea, but I don't always have all points and regions will not be fully
> filled
>
>
>
> --
> View this message in context:
> http://postgresql.1045698.n5.nabble.com/How-to-store-clickmap-points-tp5739121p5740079.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>