credativ® Blog
Here you will find interesting news about industry-specific topics and us.
Categories
Category
Category: PostgreSQL®
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 […]
