(crossposting this to hackers, I'm sure there are interested people
there as well)
Since Dave set the site up for tracking clickthroughs, I hit the db with
a couple of queries to count our downloads. This is what I came up with:
I did some simple pivoting in Excel and split it into categories win32,
source, sig (MD5 or PGP signatures), RPMs, split (the split tarballs),
pgadmin and ODBC. Other stuff was so little that I cut it.
The numbers for just-past-release may be off a bit because of the move
of wwwmaster. Not sure what happened to the db.
Just before and about 24 hours after the release of 8.0, we had the
Grand Total 27947
Total tally since the tracking started (2005-01-11):
win32 106878 56,37%
source 39058 20,60%
rpm 11703 6,17%
split 9135 4,82%
sig 8931 4,71%
pgadmin 7281 3,84%
odbc 6601 3,48%
And the versions being downloaded (total):
notpg 14526 (pgadmin, odbc etc)
Grand Total 189587
This does *not* include bittorrent downloads.
Some conclusions that I draw from this:
1) The win32 distribution is very popular. Some of this is no doubt
because it's new. Also, about 3500 of those downloads are RC5 downloads.
RC5 downloads of the source were during this time so few that they
didn't show up after my cutoff.
2) Most of the people who use RPMs on their linux systems wait for their
distribution to ship the RPMs and don't get it. Or they are alraedy set
up to download directly from their mirror and not from the website (the
tracker only counts downloads that were initiated from the website)
3) There doesnt' seem to be much point to the distribution splits. A
total of less than 5% the *number* of downloads. And most people
probably get more than one file, so in reality that number shuold
proably be divided by 4 or 5.
I know several people who downloaded source *plus* the split ones,
because "hey, I need postgresql. And I certainly need base too. And I
need docs.". They don't realise it's included in the main tarball.
Frankly, I'd suggest dropping the splits. Thoughts?
4) People upgraded to 8.0.1. Not a lot of people have upgraded their 7.4
As always, it's statistics. You can say anything you want with it...
Someone who chews numbers for a living might be able to get more out of
it. If someone is interested in the excel pivot tables with this stuff
in it, let me know. But it's nothing exciting there :)
pgsql-www by date
|Next:||From: Marc G. Fournier||Date: 2005-02-24 17:28:16|
|Subject: Re: [HACKERS] Some download statistics|
|Previous:||From: Dave Page||Date: 2005-02-24 16:31:29|
|Subject: Re: Mirror reports getting lost|
pgsql-hackers by date
|Next:||From: Bjoern Metzdorf||Date: 2005-02-24 17:22:51|
|Subject: Re: invalid multibyte character for locale|
|Previous:||From: Tom Lane||Date: 2005-02-24 16:14:07|
|Subject: Re: Finding if old transactions are running... |