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.