Postgres Pro
Downloads
Home   >   mailing lists

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

From aasat
Subject How to store clickmap points?
Date
Msg-id 1357639935360-5739121.post@n5.nabble.com
Whole thread Raw
Responses Re: How to store clickmap points?  (Ben Chobot <bench@silentmedia.com>)
Re: How to store clickmap points?  (David Johnston <polobo@yahoo.com>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Wolf Schwurack
Date:
Subject: Error: absolute path not allowed
Next
From: Scott Marlowe
Date:
Subject: Re: Error: absolute path not allowed