Featured Posts
PGDay London
Today I went along to the PG Day London. After visiting similar conferences in the past I was on the lookout for some interesting talks and refreshing my gardening wardrobe (my partner is not keen on being out with me in public wearing database software branded t-shirts).
So after braving the walk up from London Waterloo to where the conference was held (thanks TFL and the unions). I was looking forward to a cup of coffee, maybe a pastry and the keynote speech (I made it just in time after).
By Russell Morris
read morePostgreSQL-meetup-02-09-25
So the current months PostgreSQL user meetup was tonight, subjects being discussed were very large PostgreSQL type solutions. These are more analytical (OLAP) then transactional (OLTP) and better suited to the Analytical processing then pure PostgreSQL. I am not saying that PostgreSQL can not do deal with analytical workloads but these solutions are simply better at it.
But lets start with where the meetup was set. Tonight we were in the Doggett’s Coat and Badge pub by Blackfriars bridge, for me a great destination as close enough to walk from work and also a short walk to Waterloo and onto the train home, and nice beers on tap.
By Russell Morris
read moreCount and Its Many Guises
Context
So why am I blogging about the count command today? Its mainly because I keep on seeing this come up on my feed. Normally the posts are under the guise of look at this interview question or junior DBAs should know this.
Which is great but the articles rarely show why one is better then the other, or even how the query planner looks at the query that you are running. The conclusions of this blog may be the same as the quick articles but hopefully this will provide a bit more information as to the WHY. This post relates to the POSTGRES dbengine.
By Russell Morris
read more