Monday, February 19

Gianni’s PlanetPostgreSQL

PostgreSQL User Group NL

PostgreSQL User Group NL

Gianni's PlanetPostgreSQL, International News, PostgreSQL, User Group
Last week I was invited by the Dutch PostgreSQL User Group in Amsterdam to speak on PostgreSQL Administration Recipes. It was the first session of 2016, and the third since they started meeting last year. Using the simple format of a cooking recipe, I presented some techniques that a PostgreSQL DBA can use to solve recurring problems, for instance: change your password without leaving traces of the new password around; quickly estimate the number of rows in a table; see which parameters have a non-default setting; temporarily disable an index without dropping it. The last recipe was more philosophical: plan your backups, or better yet, plan your recovery! After my talk I listened to the interesting presentation from Reiner Peterke who described pg_inside, his tool for collecting (more…)

Some ideas about low-level resource pooling in PostgreSQL

Gianni's PlanetPostgreSQL, PostgreSQL
Last week at the CHAR(10) conference we had a workshop on "Cloud Databases". To put it simply: what to do when the use case requirements exceed the resources available in the database server. This was a main topic of the whole conference, and several solutions have been illustrated during the day. A common theme has been that no solution fits all the use cases, and that each solution comes with its cost; hence you have to choose the solution that your use case can afford. (more…)