On October 9th, 2024, we had the PostgreSQL October Meetup in Berlin. Amazon hosted it. Josef Machytka spoke about JSON, Aychin Gasimov spoke about new features in PostgreSQL 17.
Posted by ads' corner on Friday, October 11, 2024
On August 8th and August 15th, the first two 'PostgreSQL Hacking Workshops' took place. Robert Haas previously asked on Discord for topics, and the highest vote was for 'PostgreSQL Optimizer Methodology'. The invited attendees are expected to watch the video before, and bring questions to the workshop.
Posted by ads' corner on Thursday, August 29, 2024
On July 16th, 2024, we had the PostgreSQL July Meetup in Berlin. Adjust hosted and Neon sponsored the Meetup in their Berlin Headquarter at Prenzlauer Berg, near the TV Tower.
Posted by ads' corner on Wednesday, July 17, 2024
PostgreSQL uses Multi-Version Concurrency Control (MVCC) to manage concurrent access to the database, and store each version of a tuple in a table. To keep the database efficient, PostgreSQL employs a cleanup process called VACUUM, which removes unnecessary tuples. This not only saves disk space and keeps the database size under control, it also prevents the dreaded 'Transaction ID Wraparound' issue. Regularly running VACUUM is crucial, including on the template0 database, which is normally handled by the Autovacuum daemon. However, sometimes manual intervention is necessary.
Posted by ads' corner on Wednesday, June 19, 2024
On February 6th, 2024, we had the PostgreSQL February Meetup in Berlin. Ryan Booz presented about Super-powered Data Transformation in PostgreSQL. Artur Zakirov presented about pg_repack.
Posted by ads' corner on Wednesday, February 7, 2024
Seit einigen Jahren haben wir einen regulären Englisch Stammtisch im Norden Berlins. Wir treffen uns Dienstags und besuchen verschiedene Restaurants in der Umgebung. Für diesen Samstag hatten wir etwas anderes geplant: ein Ausflug mit dem Zug nach Magdeburg um die Stadt zu erkunden und den Weihnachtsmarkt zu besuchen.
Posted by ads' corner on Saturday, December 9, 2023
While attending a conference (yay) the discussion turned to system columns, and especially 'ctid'. This was in context of backups, and the physical position of data on disk. The question was if that can be used to determine if an incremental backup is required, and if it is enough to just copy that field where the 'ctid' points to. Not quite, but I’d like to use this question to describe the system columns more in detail.
Posted by ads' corner on Tuesday, June 28, 2022
In today’s fast development cycles and with the available, rapidly changing technologies there is less time for the rational planning of a new application. Since the database is usually the last in the development chain, programmers tend to avoid learning yet another programming language for relational databases. The PostgreSQL Project is aware of this problem.
Posted by ads' corner on Friday, April 1, 2011
Die Open Source School hat neben einigen anderen Lehrgängen auch eine Schulung für PostgreSQL im Programm. Dieses Posting hier nicht nicht ganz uneigennützig, wenn man sich anschaut, wer diese Schulung halten wird ;-)
Posted by ads' corner on Tuesday, May 6, 2008
If you use pure PHP (no database abstraction layer) with PostgreSQL, you may run into the problem that your BOOLEAN columns are not recognized by PHP but the value is instead returned as a string.
Posted by ads' corner on Monday, January 7, 2008