Month: October 2015
Indexing Wikipedia
Wikipedia is one of the most relevant collections of text data on the Internet today. It consists of countless entries covering pretty much every topic conceivable. Therefore Wikipedia is an interesting collection of text to play with. To prepare for my talk at the PostgreSQL conference in Vienna, we decided to import Wikipedia into PostgreSQL. […]
Read more
pg_stat_statements: The way I like it
If you really want to track down slow queries, massive I/O and lousy performance, there is no way around the pg_stat_statements extension. However, the pg_stat_statements system view is full of information and many people get lost. Therefore it can make sense, to come up with a clever query to provide administrators with really relevant information. […]
Read more