Re: How to store clickmap points?

On 2013-01-08, aasat <satriani@veranet.pl> wrote:
> Hi,
>
> I want to store clickmap points (X, Y and hits value) for website
>
> I currently have table like this
>
> CREATE TABLE clickmap (
>   page_id integer,
>   date date,
>   x smallint,
>   y smallint,
>   hits integer
> )
>
> But this generated about 1M rows per day.
>
> Can Postgres have better method to store this data? I also have the
> possibility to update hits value for point

convert it into a heatmap at the end of each day.

--
⚂⚃ 100% natural