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 Generally questions like this require that some knowledge of how the resultant data is going to be used in order to make appropriate design trade-offs. I would also question why you wouldn't just store the actual timestamp value as opposed to just storing the date. David J. -- View this message in context: http://postgresql.1045698.n5.nabble.com/How-to-store-clickmap-points-tp5739121p5739449.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
