How to store clickmap points?

From: aasat <satriani(at)veranet(dot)pl>
To: pgsql-general(at)postgresql(dot)org
Subject: How to store clickmap points?
Date: 2013-01-08 10:12:15
Message-ID: 1357639935360-5739121.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

--
View this message in context: http://postgresql.1045698.n5.nabble.com/How-to-store-clickmap-points-tp5739121.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message J. Hondius 2013-01-08 11:05:26 Re: lc_time not working? Solved.
Previous Message Birta Levente 2013-01-08 09:04:14 Re: PostgreSQL 9.2 and PGBOUNCER