credativ® Blog
Here you will find interesting news about industry-specific topics and us.
Categories
Category
09 September 2013
PostgreSQL® 9.3
PostgreSQL® 9.3 ist da! Die neue Hauptversion bringt viele Verbesserungen und neue Funktionen. Dieser Artikel stellt einige der interssanten Neuerungen vor. Verbessertes Locking mit Fremdschlüsseln Fremdschlüssel sind unabdingbar für die referentielle Integrität der Daten. Allerdings brachten diese bis einschließlich PostgreSQL® 9.2 auch unter bestimmten Bedingungen Lockingprobleme bei UPDATE auf Spalten mit Fremdschlüsseln mit sich. Vor […]
09 September 2013
PostgreSQL® 9.3
PostgreSQL® 9.3 is here! The new major version brings many improvements and new functions. This article introduces some of the interesting innovations. Improved Locking with Foreign Keys Foreign keys are indispensable for the referential integrity of the data. However, up to and including PostgreSQL® 9.2, these also caused locking problems under certain conditions when UPDATE […]
26 April 2011
VACUUM FULL – More is better?
VACUUM in PostgreSQL® has always been surrounded by myths and misinformation. A particularly common belief seems to be that VACUUM FULL helps as a preventive measure. In many cases, the exact opposite is true. VACUUM – The vacuum cleaner Since the introduction of MVCC (Multi Version Concurrency Control) in PostgreSQL® 6.5 in 1999, the VACUUM […]
31 March 2010
[Howto] Debian Preseed mit Netboot
The vast majority of Debian installations are simplified with the use of Preseeding and Netboot. Friedrich Weber, a school student on a work experience placement with us at our German office has observed the process and captured it in a Howto here: Imagine the following situation: you find yourself with ten to twenty brand new […]
25 February 2010
[Howto] Introduction to Puppet
The administration of a large number of servers can be quite tiresome without a central configuration management. This article gives a first introduction into the configuration management tool, Puppet. Introduction In our daily work at the Open Source Support Center we maintain a large number of servers. Managing larger clusters or setups means maintaining dozens […]
