On 2013-01-08, aasat <satriani(at)veranet(dot)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