postgresql

pgvector, a guide for DBA – Part3 AI agent and workflows

Introduction Nowadays, everyone in IT is well versed in using ChatGPT and other LLM-powered Chat to retrieve information like Google or try to learn something with it. The problem with those models is their accuracy. Current AI models only(…)

Creating your private cloud using OpenStack – (7) – Horizon, the OpenStack dashboard

We’ve finished the last post with a working Network (Neutron) service on the controller and compute node. In this post we’ll setup the final service which is Horizon, the OpenStack dashboard. Once more, looking back(…)

Creating your private cloud using OpenStack – (6) – The Networking service

We’ve finished the last post with a working Compute (Nova) service on the controller and compute node. While only the compute(s) actually run compute resources, Nova is also running on the controller for the management tasks, while libvirt is(…)

Creating your private cloud using OpenStack – (5) – The Compute service

We’re now coming closer to the final setup of the OpenStack test environment. Again, looking at the minimum services we need, there are only three of them left: Keystone: Identity service(…)

M-Files What’s new?

As you may know, M-Files is providing monthly release and the one for October is going to be interesting. Since several month M-Files is heavily working on the integration of new Microsoft approach which is aligning desktop and(…)

Introduction to PostgreSQL in OpenShift

I’m on a mission to tackle scary topics around DevOps these days! In my 2 previous blog posts (Part 1 and Part 2) I’ve tried to demystified the DevOps word (and(…)

PostgreSQL 17: Track skipped rows from COPY in pg_stat_progress_copy

In one of the last posts we’ve looked at how you tell copy to ignore any rows which do not fit into the target table starting with PostgreSQL 17. While this is great, this also(…)

PosgreSQL + SQL Server = WiltonDB – Part 1 – Installation

I know,  few years ago, it was uncredible to associate SQL Server & PostgreSQL or see Microsoft in the Open source world. 😉 The world changes and we follow it… My colleague Daniel Westermann will enjoy that(…)

PostgreSQL: Managing multiple “users” with roles

Having multiple users but don’t want them to use the same account?In such a case you can use a role to group your users together.And even better you can set default privileges for that role before creating anything(…)

PostgreSQL 16: Playing with pg_stat_io (2) – evictions

In the last post in this little series we’ve looked at the “extends” statistic in pg_stat_io. In this post we’ll look at the “eviction” statistic. Before we go into the details:(…)