Re: Popular pages on techdocs

On Fri, 14 Mar 2008, Dave Page wrote:

> You might be able to extract some useful data from Google Analytics if
> you're willing to give it a go?

I certainly was.  Ignoring the main navigation pages, here are the most 
popular pages on techdocs:

techdocs.54:  "A Guide to GUI Tools Supporting PostgreSQL"
techdocs.37:  "PGSQL Talks"
techdocs.16:  "Updating columns in PostgreSQL tables effectively"
techdocs.83:  "Why PostgreSQL Instead of MySQL"
techdocs.15:  "Using PostgreSQL's COPY function effectively"
techdocs.13:  "FAQ: Working with Dates and Times in PostgreSQL"
techdocs.29:  "HOWTO : Microsoft SQL Server to PostgreSQL Migration"
techdocs.76:  "Howto SSL enable Postgresql LDAP Authentication"

To ease the transition a prominently placed "Looking for something from 
the old site?" page linking to these might be a helpful to all the people 
who follow a now redirected link.

On the broader topic of what people look for that lands them on one of the 
docs pages (which includes both techdocs and when they are redirected onto 
a section of the manual), here are the things people search for with 
Google starting with the most popular:

alter table
change password
sequence
psql
pg_hba.conf
create table
copy
vacuum
join
update
select
count
insert
schema
auto increment
pg_dump
cast
initdb
union
coalesce
createuser
timestamp
oid
like
date
show
delete
trigger

I had been working on a more task-oriented FAQ for postgresqldocs.org, 
staring at this data makes me think that would be nice to integrate with a 
"Popular manual sections" page of some sort.  I sometimes guess what 
people want but it's always nice when it can be measured like the above 
instead.

> I am aware that some of the text we migrated is *really* old now, so a
> culling/archiving session would be a worthwhile pursuit.

While there are some recent articles like my MySQL comparision, many of 
the most popular pages were dated 2001.  There's plenty to be culled, but 
some it should be probably be refreshed instead.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD