Category: Community
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).
PostgreSQL-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.
London PostgreSQL meetup (29-07-25)
So how did you spend your tuesday evening?
Me, I spent the time hearing about different views of conversations I have had over the last couple of years/weeks/days. What do you mean I hear you ask? Well..
So I went to the meetup of London Postgresql group tonight, I will admit this was my first time and I was a bit unsure of what to expect.
What I found was the following:
Category: Tech
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).
PostgreSQL-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.
Count 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.
SQL - Execution Order
So firstly understanding
So the point of this post is to understand how the SQL engine (and this is platform agnostic) looks and understands your query.
Whilst the improvements in DB engines have been amazing over the years this topic is fundamental understanding to how the DB engine will interpret your query commands - it can mean the difference between a really happy DBA or one that is reaching for the access remove script.
EXIST or IN or ANY
Use of IN and EXISTS and ANY
So, there are various different ways to compare you datasets against a list of values, you can use IN, EXISTS or ANY keywords. The only problem is which to use and when. Please note that the contents of this post is based on my experiences - you may find this works differently with your datasets.
Please note that this post applies to Postgresql only, given that different engines treat these commands in different ways.
London PostgreSQL meetup (29-07-25)
So how did you spend your tuesday evening?
Me, I spent the time hearing about different views of conversations I have had over the last couple of years/weeks/days. What do you mean I hear you ask? Well..
So I went to the meetup of London Postgresql group tonight, I will admit this was my first time and I was a bit unsure of what to expect.
What I found was the following:
Setting the blog up and why
So this was fun
How I got here
So for some outlandish reason, I thought it would be a good idea to start a blog covering not just techncial but also the non technical stuff that I do. If no one else, I will find it usefal - but I had no idea whats I was doing. I am a DBA after all.
So what am I looking for?
So three key components:
Category: Hobbies
First Batch of cider brewing this summer
So many apples
Last year we (the royal we here) made a decision that we should be using more of the fruits that our garden produces - trust me the four apple trees in our garden, despite our best efforts on one of them produce a lot of apples, so what to do?
Lets Make cider
So last year the first batch was produced - we got 11 bottles of very drinkable (slightly dry) cider that we enjoyed. So enough reminiscing on the past its a new year so lets start the brew.
Preparing Bottles
How to wash a bottle?
You would think that this is a silly question, but its not. You have always been brought up to wash anything with washing up liquid and in the case of homebrew then to sterilise the bottles. This is fine, but it is not the best way to prepare a bottle for homebrew.
Why is this an issue?
So on my last brew of IPA I cleaned and sterilised my bottles as I usually would:
Category: Other
First Batch of cider brewing this summer
So many apples
Last year we (the royal we here) made a decision that we should be using more of the fruits that our garden produces - trust me the four apple trees in our garden, despite our best efforts on one of them produce a lot of apples, so what to do?
Lets Make cider
So last year the first batch was produced - we got 11 bottles of very drinkable (slightly dry) cider that we enjoyed. So enough reminiscing on the past its a new year so lets start the brew.
Preparing Bottles
How to wash a bottle?
You would think that this is a silly question, but its not. You have always been brought up to wash anything with washing up liquid and in the case of homebrew then to sterilise the bottles. This is fine, but it is not the best way to prepare a bottle for homebrew.
Why is this an issue?
So on my last brew of IPA I cleaned and sterilised my bottles as I usually would: