Neues vom PostgreSQL Planet
Python 2 has officially completed its life as of Jan 1st, 2020 and the Python 2.x branch will not be maintained anymore. You might be seeing repeated notices of deprecation in log files and terminals like:
As I get ready for the PgDay San Francisco event that is happening next Tue 21 January—a one-day, single-track Postgres community event at the awesome Swedish American Hall in SF—I’m reflecting a bit on how important the speakers are to developer events. Let’s face it, without speakers, there would be no conference.
Andreas 'ads' Scherbaum
The PostgreSQL Project is present with a booth at FOSDEM ever since 2007. Since 2008 we organize a Devroom, since 2013 we have our own PGDay on the Friday before FOSDEM. This year marks the 8th FOSDEM PGDay.
This blog post presents useful information about the PGDay, the booth and Devroom at FOSDEM.
Continue reading "PostgreSQL @ FOSDEM 2020"
FOSDEM PGDay is looking for volunteers! We rely on you to help us host and run a successful FOSDEM booth and devroom.
The areas covered by volunteers include, but are not limited to:
- room host (Devroom, Sunday)
- video host (Devroom, Sunday)
- door bouncer (Devroom, Sunday)
- booth volunteers (Saturday, Sunday)
Room volunteers have the advantage that they have a guaranteed place in the devroom during their Sunday shift.
Quite often when visiting customers or doing trainings, I see that people are quite happy seeing and learning about some little time-saving PostgreSQL tricks, commands or SQL snippets on the screen and they usually ask to slow down and explain or just say “wow, didn’t know you could do that”.
For connection pooling in PostgreSQL, one of the best and most popular tools out there is PgBouncer. However, monitoring PgBouncer can be challenging due to its use of SHOW commands, which are only available via a special database connection as opposed to making its statistics available via a standard table or view.
Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 13 – ALTER TABLE … ALTER COLUMN … DROP EXPRESSION
The 6th edition of the popular PostgreSQL conference pgDay Paris, a PostgreSQL.Org Recognized Community Conference, will be held on March 26, 2020 in the French capital. All of the talks will be in English.
Registration is open, and the EARLYBIRD discount is going fast so make sure you grab that while you can! https://2020.pgday.paris/registration/
2020 January 16 Meeting 6pm-8pm
PSU Business Accelerator
2828 SW Corbett Ave · Portland, OR
Parking is open after 5pm.
Speaker: Alex Theodore
PostgreSQL is one of the most popular free open-source relational database management systems in the world. Other than complies to SQL standard, PostgreSQL also provides a great extensibility which allows users to define their own extensions. With such a great feature, PostgreSQL is not only a database but also an application development platform. In this tutorial, we will go through the entire process about creating an extension, running test against this extension, and debugging the extneson using Eclipse.
This tutorial provides detailed instructions to help a newbie setup the building and debugging environment with the latest Eclipse IDE for C/C++ Developers for current Postgres 12.1 release on LTS Ubuntu 18.04.
Below is the key requirement.
This year's FOSDEM PGDay once again precedes the main FOSDEM event. It will take place on January 31st, 2020, in the Hilton Brussels Grand Place Hotel.
Registration for the PGDay is open, and a registration is required to attend the Friday conference. The number of seats is limited. Visit the Registration page for your ticket!
Hubert 'depesz' Lubaczewski: Finally – fixed time calculations for parallel plans in explain.depesz.com
Coming up with good index suggestion can be a complex task. It requires knowledge of both application queries and database specificities. Over the year multiple projects tried to solve this problem, one of which being PoWA with the version 3, with the help of pg_qualstats extension. It can give pretty good index suggestion, but it requires to install and configure PoWA, while some users wanted to only have the global index advisor.