Tuning your PostgreSQL database is somewhat of a black art. While documentation does exist on the topic, many people still find it hard to get all the power out of their system. This article aims to help demystify PostgreSQL database performance tuning.
Query log data for ad targeting
A WWW2006 paper out of Microsoft Research, "Finding Advertising Keywords on Web Pages" (PDF), claims that query log data is particularly useful for ad targeting.
Specifically, the researchers extracted from MSN query logs the keywords some people used to find a given page. They tested using that as one of many features for ad targeting. In their results, it was one of the most effective features.
Very interesting. It has always been harder to target ads to content than to search results because intent is much less clear.
By using the query log data in this way, the researchers were effectively using the intent of the searchers that arrived at the page as a proxy for the intent of everyone who arrived at the page.
Query log data for ad targeting
A WWW2006 paper out of Microsoft Research, "Finding Advertising Keywords on Web Pages" (PDF), claims that query log data is particularly useful for ad targeting.
Specifically, the researchers extracted from MSN query logs the keywords some people used to find a given page. They tested using that as one of many features for ad targeting. In their results, it was one of the most effective features.
Very interesting. It has always been harder to target ads to content than to search results because intent is much less clear.
By using the query log data in this way, the researchers were effectively using the intent of the searchers that arrived at the page as a proxy for the intent of everyone who arrived at the page.
select min(seq) seq,state,count(*) numb_ops, -> round(sum(duration),5) sum_dur, round(avg(duration),5) avg_dur, -> round(sum(cpu_user),5) sum_cpu, round(avg(cpu_user),5) avg_cpu -> from information_schema.profiling -> where query_id = 7 -> group by state -> order by seq;
B. Fonseca, P. Golgher, B. Pôssas, B. Ribeiro-Neto, and N. Ziviani. CIKM '05: Proceedings of the 14th ACM international conference on Information and knowledge management, page 696--703. New York, NY, USA, ACM Press, (2005)
J. Cugini. Information Doors -- Where Information Search and Hypertext Link workshop (held in conjunction with the ACM Hypertext and Digital Libraries conferences)., San Antonio, Texas, (2000)
J. Cugini, S. Laskowski, and M. Sebrechts. IST/SPIE's 12th Annual International Symposium: Electronic Imaging 2000: Visual Data Exploration and Analysis (SPIE 2000), San Jose, CA, (2000)
G. Stumme. Conceptual Structures at Work: 12th International Conference on Conceptual Structures (ICCS 2004), volume 3127 of LNCS, page 109-125. Heidelberg, Springer, (2004)