Whatever you did to get 1 million points a day on your site.. I want in.. the name of your marketer please!
I agree with condensing this into a heatmap or a set of RRDs.. one for X.. one for Y.. one for x * (y * max_height)). You can easily query RRDs later on.. even multiple RRD files at once. Also.. don't be afraid of flat files. They compress well. - Shane On Mon, Jan 14, 2013 at 5:29 AM, aasat <satri...@veranet.pl> wrote: > > Instead of storing x/y, have you considered referencing a region of > pixels? > The bigger the region, the larger your possible savings. > > Good idea, but I don't always have all points and regions will not be fully > filled > > > > -- > View this message in context: > http://postgresql.1045698.n5.nabble.com/How-to-store-clickmap-points-tp5739121p5740079.html > Sent from the PostgreSQL - general mailing list archive at Nabble.com. > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
