Re: How to store clickmap points? - Mailing list pgsql-general

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
possiblesavings.