Re: downloads & usage of Postgres on a per city

Поиск
Список
Период
Сортировка
От Magnus Hagander
Тема Re: downloads & usage of Postgres on a per city
Дата
Msg-id 45846E22.6080902@hagander.net
обсуждение исходный текст
Ответ на Re: downloads & usage of Postgres on a per city basis  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: downloads & usage of Postgres on a per city  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-advocacy
Josh Berkus wrote:
> Darcy,
>
>> Do you have IP addresses, if so I can convert those to country with
>> somewhere around 95% accuracy
>
> I'll check.  Unfortuntely, I'm leaving town in 2 days so now is not the ideal
> time to produce such figures.  The downloads database is on wwwmaster if you
> want to take a stab at it, but I have normalization code that weeds out
> duplicates and sorts by PG version & platform.
>

The database on wwwmaster already contains the country code as returned
by the ip-to-country mapping that's in the wwwmaster database. I'm
unsure of how updated it is, but it should give you most of them the
right way. So you can just use the field "country" along with whatever
normalization you were already doing.

//Magnus

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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: downloads & usage of Postgres on a per city basis
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: downloads & usage of Postgres on a per city