PostgreSQL performance tuning for faster query execution

PostgreSQL is a reliable open source database available in many modern distribution’s repository. The ease of use, the ability to use extensions and the stability it provides all add to it’s popularity. While providing the base functionality, like answering to SQL queries, store inserted data consistently, handling transactions, etc. most mature database solutions provide tools … Leggi tutto

How to create a hot standby with PostgreSQL

PostgreSQL is an open source RDBMS (Relational DataBase Management System), and with any databases, the need may arise to scale and provide HA (High Availability). A single system providing a service is always a possible single point of failure – and even with virtual systems, there may be a time when you can’t add more … Leggi tutto

PostgreSQL 10 Released

The PostgreSQL Global Development Group today announced the release of PostgreSQL 10, the latest version of the world’s most advanced open source database. This release also marks the change of the versioning scheme for PostgreSQL to a “x.y” format. This means the next minor release of PostgreSQL will be 10.1 and the next major release … Leggi tutto

Progetto automazione LABijk. Revisione 1.

Il progetto intende promuovere tecnologie open source ed open electronics. Si supponga di voler gestire sensori ed attuatori. Poniamo al centro un microserver, con sistema operativo Linux Server, eventualmente connesso ad internet ed a reti locali. Questa macchina archivia un resoconto di tutto quello che viene fatto e comunica con tablet, telefoni ed altri sistemi … Leggi tutto