Infrastructure at your Service

Category

Database Administration & Monitoring

Daniel Westermann

Feeding blogs/rrs items directly into your PostgreSQL database

By | Database Administration & Monitoring | No Comments

There are many foreign data wrappers available for PostgreSQL. One of them can be used to query rss feeds. In this post I’ll show you how you can feed summary information of a blog into your PostgreSQL database. The foreign data wrapper you’ll need to download and install is called multicorn. This foreign data wrapper in fact brings more than a rss wrapper which is documented here. Installation is quite easy: [email protected]:/var/tmp/ [PG8] unzip multicorn-1.3.2.zip…

Read More
Franck Pachot

12c multitenant: Cursor sharing in CDB

By | Database Administration & Monitoring | 4 Comments

By Franck Pachot . In multitenant, there are two goals: consolidation within the same container database and isolation of pluggable databases. I see multitenant consolidation as an extension of schema consolidation. What is not possible in schema consolidation, such as public objects name collision, is now possible with pluggable databases. 10 years ago I administrated on a database with high level of consolidation: 3000 schemas with same structure and different data. The big scalability issue…

Read More
Daniel Westermann

Pre-warming the buffer cache in PostgreSQL

By | Database Administration & Monitoring | No Comments

When a database gets shutdown for patching, operating system maintenance or other reasons you completely lose the contents of the buffer cache. No surprise. Memory is not persistent. Wouldn’t it be nice to load the most important tables to the cache when the instance starts automatically? This would reduce the time for the most important queries to return the results as blocks would not be needed to read from disk. PostgreSQL has a solution for…

Read More
Daniel Westermann

Transactional DDL

By | Database Administration & Monitoring | No Comments

When you are working on Oracle you probably learned that each DDL does an implicit commit in the background. There is no way to have DDLs wrapped in a real transaction (with the exception of the “create schema” command which I blogged about a long time ago). If you take a look a the SQL:2008 standard (ISO/IEC 9075-1:2008) you can find this: “An SQL-transaction (transaction) is a sequence of executions of SQL-statements that is atomic…

Read More
Daniel Westermann

Install PL/JAVA in Postgres Plus Advanced Server 9.5

By | Database Administration & Monitoring | 28 Comments

While doing a project at a customer we came to a point where we needed to install pl/java into Postgres Plus Advanced Server 9.5. If you follow the official documentation you will probably fail and get stuck when trying to build pl/java with maven (at least I did fail several times). Unfortunately there is not much documentation around for solving the issues that popped up. As we have a very good communication channel into EnterpriseDB…

Read More