Contact
Offices

PostgreSQL

Christoph Berg
Today PostgreSQL version 11 was released. The new release brings improvements in many areas. Since version 9.6 query plans can be executed on multiple CPU cores in parallel, this is now supported for other plan types, especially the creation of B-tree indexes. Sequential scans and UNION queries...
Carsten Meskes
From mid to late June credativ attended 3 consecutive conferences in Asia. The Open Source Summit Japan , the LC3 China and the PG Open China . Open Source Summit Japan As in the previous year, the Open Source Summit Japan was held again at the Ariake Conference Center on Odaiba, in the Bay of...
Michael Banck
The second beta release of PostgreSQL 11 (which is now feature frozen) has been released recently. Time to look at some of the improvements that credativ has contributed in the area of checksums and backups. Checksum verification during base backups Since version 9.3 it is possible to enable...
Philip Haas
For the fifth time now, credativ is sponsoring PostgresConf US as a silver level sponsor. PostgresConf US 2018 will take place at the Westin Hotel in Jersey City, New Jersey from the 16 th to the 20 st of April. As always there are numerous interesting presentations on the agenda , that are divided...
Carsten Meskes
The credativ PostgreSQL Competence Center has released a project roadmap for the PostgreSQL appliance Elephant Shed . Elephant Shed is a freely available PostgreSQL solution developed by credativ, which combines management, monitoring and administration into one system. The project roadmap for 2018...
Christoph Berg
Elephant Shed is now available as a Vagrant box . This makes it very easy to test and try out the PostgreSQL appliance. Vagrant is an Open Source tool for creating portable virtual software environments. By being fully script controlled Vagrant makes it easy to generate virtual machines, in which a...
Philip Haas
Open Source Summit Europe 2017 took place from October 23rd to October 26th at the Hilton Hotel Prague. It was the first Open Source Summit in Europe since LinuxCon, CloudOpen and ContainerConf were merged to form this joint event. The number of visitors alone, with about 4000 people, was...
Julian Schauder
Next to the indextypes like B-tree and BRIN, PostgreSQL supports hashindexes now for a long time. This index however was usually not recommended, as a lack of REDO-information in our transactionlog (Write Ahead Log, WAL) prevented replication and crash safety. A crash of the service could hence...
Philip Haas
Next Monday the Postgres Vision 2017 in Boston begins. credativ is sponsoring the event as we did last year and we are looking forward to seeing many familiar and new faces. The 3-day event takes place at the Royal Sonesta Hotel, and again this year it attracts a large number of PostgreSQL...
Phillip Warwick
Written by Adrian Vondendriesch. With PostgreSQL 9.6, the known View pg_stat_activity is extended by two columns: wait_event and wait_event_type . These replace the old column waiting . Background PostgreSQL distinguishes internally between two lock types: heavyweight Locks and lightweight Locks (...