Database Administration & Monitoring PostgreSQL partitioning (1): Preparing the data set 02.06.2019 by Daniel Westermann This is the start of a series about partitioning in PostgreSQL. For this and the following posts I will use PostgreSQL 12 (which currently is in beta) so some stuff might not work if you are on PostgreSQL 11 or(…)
Database Administration & Monitoring PostgreSQL 12: New partition reporting functions 02.06.2019 by Daniel Westermann PostgreSQL 10 introduced declarative partitioning (with some limitations), PostgreSQL 11 improved that a lot (Updating the partition key now works in PostgreSQL 11, Insert…on conflict with partitions(…)
Database Administration & Monitoring PostgreSQL 12: Control when generic plans are used 31.05.2019 by Daniel Westermann When you are using prepared statements in PostgreSQL you might get a custom or a generic plan. Custom plans come with overhead of re-planning while generic plans avoid re-planning of the statement.
Database Administration & Monitoring Securely store passwords in PostgreSQL 31.05.2019 by Daniel Westermann Every application somehow needs to deal with passwords. Some use external authentication methods such as ldap, others us the the framework the database already provides and create users and roles. But it is also not uncommon that applications implement their(…)
Database Administration & Monitoring Can you start two (or more) PostgreSQL instances against the same data directory? 30.05.2019 by Daniel Westermann As PostgreSQL does not know the concept of running multiple instances against the same files on disk (e.g. like Oracle RAC) it should not be possible to start two or more instances against the same data directory. If that would(…)
Cloud, Database Administration & Monitoring, Database management, Oracle What Benefit You Get From The Cloud For Your Business? 29.05.2019 by Oracle Team Microsoft, Amazon, Google and Oracle offer infrastructure services whose names change, but the concepts remain the same. It may be that you are interested in the cloud too, but it's still not clear because you find(…)
Database Administration & Monitoring SUSE Expert Day Zürich 28.05.2019 by Gérard Wisson On May 16th I visited the SUSE Expert Day in Zürich. An interesting Agenda was waiting for me, all under the topic: "My kind of open"(…)
Application integration & Middleware, Database Administration & Monitoring APEX Connect 2019 – Day 3 09.05.2019 by Alain Lacour For the last conference day, after the Keynote about “JavaScript, Why Should I Care?” by Dan McGhan , I decided to attend some JavaScript learning sessions to improve myself and presentations on following topics: – How to hack your(…)
Application integration & Middleware, Database Administration & Monitoring APEX Connect 2019 – Day 2 08.05.2019 by Alain Lacour The day first started with a 5K fun run. After the Keynote about “APEX: Where we have come from and where we’re heading: Personal insights on Application Express from the Development Team” by John Snyders, Anthony Rayner and Carsten Czarski(…)
Database Administration & Monitoring, Oracle Oracle 19C : Exporting and Importing Broker Configuration 04.05.2019 by Oracle Team By Mouhamadou Diaw Up to Oracle 19c, there was no automatic way to backup the configuration of the broker. One solution was to manually copy all executed instructions in a file. With Oracle 19c, there is now the possibility(…)