Category Archives: news

Just announced: PG DATA 2026

Chicago is better in summer! Our inaugural event, PG DATA 2026, will kick off 363 days from today, and we want you to be a part of it!

PG DATA’s mission is to encourage the growth of the PostgreSQL community in the Midwest through learning and networking opportunities, to foster collaboration with the developers’ community and academia, and to bring the best global Postgres speakers to our local community.

More details are coming soon! Watch for further announcements, and do not plan your vacation for the first week of June 2026. Alternately, make Chicago your vacation destination—our beautiful city has a lot to offer, especially in summer!

Call for Sponsors is open!

3 Comments

Filed under community, events, news

Please Welcome Prairie Postgres!

Dear Postgres Community! In this post, I want to formally introduce Prairie Postgres, a project that has kept me really busy for the past several months.

Recently, you’ve seen a lot of me online, talking about things I want to do and things I am already doing. Thinking about all these activities holistically, I can group them all around three common themes: Postgres “elementary education,” connecting with application developer communities, and connecting with educational institutions. The overall goal is broader promotion of knowledge about Postgres and its best practices.

Why do I think this is important? Postgres is undoubtedly the most beloved and most well-known open-source database, but too many people jump into the ocean of possibilities without being equipped with even basic knowledge. This creates a barrier for adoption and results in disappointments and not being able to get the most out of PostgreSQL.

The most important mission of Prairie Postgres is creating Postgres educational opportunities in the United States Midwest States. We want to focus on Midwest because other parts of the US have PostgreSQL User Groups and conferences, and the Midwest has a lot of Postgres but not enough community activities. We know that there are many people in the region working with Postgres, and we want to reach out to them. I often hear the sentiment that we see “all familiar faces” at Postgres events, and this includes not only the speakers, but the attendees as well, and we want to change that.

We are making our very first steps, but even these first steps wouldn’t be possible without tremendous help from many people. Firstly, I want to thank Pat Wright who gave me the idea to create an NFP, and then helped navigate the legal field – I can’t even imagine how long it would have taken us without his help.

Next, I want to thank Dian Fay and Anna Bailliekova, Prairie Postgres co-founders, who jumped into this adventure and took upon themselves the most important task of never letting me make any decisions by myself without their consent. Shaun Thomas and Carlos Aranibar have stepped up to join our board and help us with both educational content and operations.

Lastly, I can’t thank enough Sarah Conway, who volunteered to help us with the website and social media content (please follow us on LinkedIn and Mastodon) . Her work can’t be overestimated (I do not know how she finds time to do that all!). I will say one thing: if this post is not the first time you hear about Prairie Postgres, that’s due to Sarah’s efforts!

We are in the very beginning of our journey, but we hope to work in close collaborations with all PostgreSQL NFP and the Core Team to benefit Postgres Project and Postgres Community.

Finally – a small ask :). We are trying to bring more students from Chicago schools to PG Day Chicago. We are sponsoring a half of the student’s tickets price, but for many students, even a half-price is too much. An extra $75 will help one student to attend PG Day Chicago for free. Any donations to Prairie Postgres starting from today and until April 24, will be used towards student attendance.

Many thanks 🙂

2 Comments

Filed under community, news

PostgreSQL 17 features I am most waiting for

I won’t be able to attend Magnus’ talk at PG Day Chicago because it is scheduled at the same time as my talk, but fortunately, I attended his talk at SCaLe. There are several features I am really excited about, and I can’t wait to start using them!

  1. Event trigger on login. Yes, yes, I know, Magnus told us it’s a footgun, but I promise, I know how to use it safely! I have so many potential usages!!!
  2. Error handling in COPY. Since I started my new development with pgBadger, my biggest fear is that if just one record is somehow wrong, the whole file won’t load, and I can’t do anything with that – except for that now I can!!!
  3. PgChangePassword!!! I have security-defined functions to handle that because what could be more natural than giving the user an option to change their own password?! Well… except for that, way too often, there is one user for the whole department… but we will address it later!
  4. Redundant NOT NULL removal – that’s great!!! Such a time-saver! And again, what can be ore natural?!
  5. Self-join removal!!! I can’t even tell how many times I fought with this problem starting from my Sybase days and all the way through my Oracle days! How many times I had to explain this “magic” to people! And now, finally, I will be able to remove this explanation from our performance book!
  6. You might think that my favorite feature is the temporal primary key – well, it is; however, I have already started to worry about what’s next. The temporal PK is implemented just as it should be, but what I see in the future code temporal foreign key makes me worried. And nobody answers my concerns, so I do not know how loud I should scream!

Summary: if you didn’t hear this talk yet, please go to this talk at PGDay Chicago – I will be happy to lose this competition :))

4 Comments

Filed under news, SQL, talks

PG Day Chicago 2024!

Please join us in Chicago on April 26, 2024, for the 2nd PG Day Chicago! See details on the conference website. This time, the venue will be in the Loop (311 W. Monroe Street), which should be more convenient for both local participants and out-of-town visitors.

The Call for papers is open, as well as the Call for sponsors, and as always, we are looking for volunteers! Please visit our website for all of the information, and please consider submitting, sponsoring, and coming :).

Leave a comment

Filed under events, news

P99 Online Conference, and What’s New in NORM?

The P99 conference will be held online on October 18-19 2023, and I will present another short talk on NORM. This talk will be really short (I know it’s hard to imagine me giving a 20-minute presentation!), but those were the requirements.

I am glad that I had an opportunity to present at this conference because that means that I am presenting not just for the Postgres community but for people in all different IT roles who are concerned about performance, and that’s exactly my target audience. I hope that at least some of the thousands of participants will actually watch my talk :).

Meanwhile, while I was getting ready for this presentation, we had a lot of updates in the NORM Repo, and if you follow us there, you already saw the massive changes.

The most important change is the removal of the NORM_GEN subdirectory. During the past two years, NORM migrated from being “a concept” or “a methodology” to a tool capable of generating Postgres types and functions. Now, it is indeed “an automated Hettie.” We moved an old “account” example to the small_example subdirectory, but instead, there are several complete examples of application/db mappings available in the examples directory. All of the examples use the postgres_air database (the new 2023 version). The run_examples.sql executes all examples.

And finally – what everybody was waiting for – a complete User Guide on how to use NORM, how to create mapping schemas, the keywords usage, and much more – User Guide.

Please check it out! I contemplated the idea to publish the NORM User Guide here as a separate blog post, but this idea was rejected.

Please take a look!

Please give it a try!

And please give us feedback!

Leave a comment

Filed under news, publications and discussions, talks

Optimization Book 2.0

Dear friends and colleagues, we are about to start working on the second edition of PostgreSQL Query Optimization! Since the time the first edition was published two years ago, we have received a lot of thanks and a lot of comments and suggestions! I wanted to thank everyone who took the time to reach out, pointing out inaccuracies, typos, factual mistakes, imperfect code formatting, etc. All feedback was saved so that issues could be addressed in the second edition.

If you have some feedback you can share, if you’ve noticed something while reading the book or running examples from the postgres_air database, if you have comments, if you noticed typos – please-please-please reach out! We want to hear from you!

Thank you, and good luck to us 🙂

Leave a comment

Filed under news, publications and discussions

POSTGRES_AIR updates

Thanks to our GitHub followers and many people who had given a try to previous versions of the postgres_air database and provided valuable feedback, we are now happy to announce that we are releasing a new version!

In addition to moving the timestamps one more year forward (the new “today” is August 17, 2023), there are multiple important fixes based on the feedback received from our amazing followers and book readers:

  • Arrival timestamps were corrected to make the flight durations consistent with distances. This change resulted in inconsistent itineraries for some bookings. To address that issue, the inconsistent flights were rebooked.
  • Inconsistently named integrity constraints renamed.
  • Overlapping bookings for the same passenger are replaced with bookings for other passengers.
  • The problem of overbooked flights is addressed in three different ways: (1) additional flights, (2) aircraft change (to larger capacity), and (3) rebooking passengers.
  • The backup contains stored procedure postgres_air.advance_air_time ( p_weeks int default 52, p_schema_name text default ‘postgres_air’, p_run boolean default false)
  • This procedure moves all the dates in the schema for the number of weeks specified by the first parameter.

As always: please give it a try, and please let us know what we have forgotten this time!!!

Leave a comment

Filed under news

My Talk At Citus Con

It is impossible to be present at two conferences simultaneously, but that’s why we have on-demand talks!

CitusCon is on April 18-19, and my brand new talk Implementing Temporal Features in PostgreSQL: SQL Standard and beyond will be available!

Leave a comment

Filed under events, news

PG Day Chicago 2023: CfP open, call for volunteers

Dear Chicago PostgreSQL Community, friends and colleagues, and the PostgreSQL community at large! As you may already know, PG Day Chicago will happen for the first time on April 20, 2023, and I can’t tell enough how excited I am about that! 

Here are several important things I wanted to highlight.

First – the call for proposals. We understand that the pre-holiday rush is not necessarily the best time to work on proposals, so we extended the deadline to January 17 (adding MLK day for those lucky to have it off!).

Second – sponsorship on all levels is available; the sponsorship prospectus can be found here.

And last but not least – we need volunteers! Lots of them! Just a reminder – if you volunteer for the event, you get free admission :). Volunteering opportunities include:

  • stuffing the bags the day before the event
  • site set up (333 Green Street) the day before the event and the morning of the day of the event
  • registration desk (the day of the event)
  • sessions hosts
  • site taking down (after the event)

Watch for the volunteer application form coming up shortly!

Leave a comment

Filed under events, news

The postgres_air makeover

We created postgres_air – the largest publically available Postgres database while we worked on our book PostgreSQL Query Optimization, thereby that version has “today” set to August 18, 2020. While we want to keep this version available to our readers until the book’s next edition is out, we also want to provide a more up-to-date version. 

This updated version is now available as postgres_air_2022.backup. 

The following changes were made to the data set:

* “today” is now August 18, 2022

* to adequately reflect the current situation, all Russian airports are excluded from the bookings. The Postgres Air airline company complies with international sanctions and no longer flies to Russia.

Flights within Russian Federation are covered by PostgresPro within their airline database 

Leave a comment

Filed under news, SQL