Infrastructure at your Service

PostgreSQL Archives - Blog dbi services

Daniel Westermann

Can I do it with PostgreSQL? – 18 – Instead of triggers on views

By | Database Administration & Monitoring | No Comments

It has been quite a while since the last post in this series but today comes the next one. Being at a customer this morning this question popped up: Can we have instead of triggers on a view in PostgreSQL as well? I couln’d immediately answer (although I was quite sure you can) so here is the test. I took an example for Oracle from here and re-wrote it in PostgreSQL syntax.  

 
Read More
Daniel Westermann

Auto pre-warming in EDB Postgres Advanced Server 10

By | Database Administration & Monitoring | No Comments

Some days ago EDB Postgres Advanced Server 10 was released and one feature which might be handy is auto pre-warming. What this does is to save all the buffers (or better a description of the buffers) which are currently loaded in to shared_buffers to disk and then re-read the buffers automatically when the instance is restarted. Lets see how it works.  

 
Read More
Daniel Westermann

Displaying the contents of a PostgreSQL data file with pg_filedump

By | Database Administration & Monitoring | No Comments

Did you ever wonder what exactly is in a PostgreSQL data file? Usually you don’t care, I agree. But there might be situations where knowing how you can do this might be a great help. Maybe your file is corrupted and you want to recover as much data as possible? Maybe you just want to do some research. There is a utility called pg_filedump which makes this pretty easy. Lets go …  

 
Read More
Daniel Westermann

Can I have the same table published and subscribed (bi-directional) in PostgreSQL 10 logical replication?

By | Database Administration & Monitoring | No Comments

When you start using PostgreSQL 10 logical replication you might think it is a good idea to setup bi-directional replication so you end up with two or more masters that are all writable. I will not go into the details of multi master replication here (conflict resolution, …) but will show what happens when you try to do that. Lets go …  

 
Read More
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