Freshly baked PostgreSQL 12 and changes it brought to pgCenter
PostgreSQL 12 release is expected today and just by looking at the prerelease notes this release is impressive – features added in the previous versions, became more…
Filters
pgCenter’s wait events profiler
As you might know, in the last pgCenter release the new tool has been added – wait events profiler. In this post, I’d like to explore this…
pgCenter 0.6.0 released.
Great news for all pgCenter users – a new version 0.6.0 has been released with new features and few minor improvements. Here are some major changes: new…
Keeping Postgres tidy with partitioning
If you are in doubt whether partitioning is a useful tool with this one example I’m hoping you won’t wonder any further. Let’s assume we have some…
Why avoid long transactions?
The majority of PostgreSQL community clearly understands why long and idle transactions are “bad”. But when you talk about it to the newcomers it’s always a good…
Global shortcuts and PostgreSQL queries.
Using your favorite hotkeys on queries in Linux One of my colleagues often talks about using hot keys for his favourite SQL queries and commands in iterm2…