Infrastructure at your Service

PostgreSQL Archives - Page 2 of 18 - Blog dbi services

Daniel Westermann

Are temporary tables auto vacuumed in PostgreSQL?

By | Database Administration & Monitoring | No Comments

While doing the EDB quiz at their booth last week at pgconfeu one of the questions was: Are temporary tables auto vacuumed? What do you think? My first thought was yes, but lets see. The first question we need to answer is: How can we check if a table (no matter if temporary or not for now) was auto vacuumed or not? PostgreSQL comes with many views that expose statistical information and one of those…

 
Read More
Daniel Westermann

2017.pgconf.eu, some impressions

By | Database Administration & Monitoring | No Comments

After we survived the EDB Postgres Rocks cafe on Tuesday, Wednesday was packed with interesting sessions. Especially listening to Robert Haas is always fun and interesting. Getting information directly from the people who work on the core code is one of the beauties of the PostgreSQL community. Several other core developers had sessions as well, and all of them were great. Thanks for all of that.  

 
Read More
Daniel Westermann

2017.pgconf.eu started, and look who is there …

By | Database Administration & Monitoring | No Comments

So, finally 2017.pgconf.eu started today and while checking the schedule I noticed something that I could not even imagine some years ago. There is a session from Microsoft: Latest update on Azure managed service for PostgreSQL. Personally I really like to see that Microsoft is more and more present at Open Source conferences and starts engaging in the community. But, of course this is not the only session that will be interesting. There is an…

 
Read More
Mouhamadou Diaw

PostgreSQL Index Suggestion With Powa

By | Database Administration & Monitoring | No Comments

A few time ago my colleague Daniel did a blog about POWA. In a nice article he shown how this tool can be used to monitor our PostgreSQL. In this present article I am going to show how this powerful tool can help by suggesting indexes which can optimize our queries. I am using postgeSQL 9.6 [root@pgservertools extension]# yum install postgresql96-server.x86_64 [root@pgservertools extension]# yum install postgresql96-contrib.x86_64 And Then I initialize a cluster [root@pgservertools extension]# /usr/pgsql-9.6/bin/postgresql96-setup…

 
Read More
Daniel Westermann

Announcing the dbi OpenDB Appliance

By | Database Administration & Monitoring | No Comments

As already announced on Twitter and LinkedIn here is the blog post to describe our OpenDB appliance in more detail. I am sure you wonder what this is about so let me explain why we are doing this. What we do see day by day at our customers is that more and more databases get consolidated on to a VMWare deployment. This is not only true for the smaller ones of those but also for…

 
Read More