Re: How to store clickmap points?

Поиск
Список
Период
Сортировка
От Shane Spencer
Тема Re: How to store clickmap points?
Дата
Msg-id CANmUDYtt=NsfA6MC9Qpd3mUXVrKQ8_gpHGq4Hf38C2iFyqMEog@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How to store clickmap points?  (aasat <satriani@veranet.pl>)
Ответы Re: How to store clickmap points?  (aasat <satriani@veranet.pl>)
Список pgsql-general
Дерево обсуждения
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 <satriani@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

В списке pgsql-general по дате отправления:

Предыдущее
От: Edson Richter
Дата:
Сообщение: Re: Triggers operations and log_statement = all not working?
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: Sample databases