Re: How to store clickmap points?

On Jan 8, 2013, at 2:12 AM, aasat 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

Instead of storing x/y, have you considered referencing a region of pixels? The bigger the region, the larger your possible savings.