Category Archives: Uncategorized

Listening to John “maddog” Hall at SCaLE x23

That was the first time I listened to John “Maddog” Hall, a “live Linux legend.” To say I enjoyed this talk is not enough: I absorbed every minute of it. Everything he said really resonated with me. I felt reassured that what I am trying to do in Postgres education, all we are doing at Prairie Postgres, is the right thing to do.

I am honored to be an LPI Board member and to contribute to this organization’s work.

I spoke at the same track on the same day, but with way fewer people present 🙂

A picture taken at the LPI booth with other Board members:)

All the talks were livestreamed and are available here:

Leave a comment

Filed under events, People, talks, Uncategorized

PG Day Chicago: The talks I am most excited about, Part I

Last year, I really enjoyed blogging about the PG Day Chicago talks I was most excited about, so this year, I decided to do it again.

Looking at the conference schedule, I can hardly find a talk I am not excited about, so I am going to say a word or two about each of them.

Ryan Booz 1 Billion rows challenge. Recently, I participated in several discussions about the unfairness of different database engine performance comparisons. When it comes to Postgres, the most commonly used “weapon” is to use a Postgres instance with default configuration parameters. And we always let it go! I hope that in this talk, Ryan will show us an example of fair comparison!

Keiko Odo Practical Query Tuning. I am always interested in query-tuning talks because that’s the most exciting and rewarding part of working with databases.

Chelsea Dole Table Bloat- managing your tuples graveyard. I will be honest. I heard this talk twice, so there is a high chance I will skip it this time, but I can’t even describe how happy I am that Chelsea finally brought it to Chicago. It’s a great talk!

Shaun Thomas Living on the Edge. Shaun’s talks are always fun and very educational, and also I am eager to learn what he is up to at PgEdge!

Baovola, with her talk The Power of Feedback, has a very special place in my heart. She is an absolutely extraordinary person who organized the first PostgreSQL User Group in Africa and put together the first even in a record time! I can’t wait to meet her in person!

Gülçin Yıldırım Jelínek Anatomy of table-level locks. I just listened to this talk at SCaLE 22x, and loved it! It’s a very complicated topic where most practitioners feel unsure, and the presentation is perfect! Same as with Chelsea’s talk, I am thrilled that it will be presented to our Chicago audience/

Th be continued!

1 Comment

Filed under Uncategorized

Alicja’s Petition: One Month Later

It has been over a month since I posted my support for Alicja Kucharczyk’s petition. In that post, I was as explicit as possible about not penalizing individuals based on their citizenship. Unfortunately, many commentators kept accusing me of that, and I ended up repeating the same arguments over and over again.

I am not going to do that anymore. Those who wanted to take my arguments in already did so, and all of us (myself included) have confirmation biases. Each of the facts discussed in my post and Alicja’s petition could be theoretically explained in some innocent way, and I will not challenge each of these possible explanations.

I understand that I can’t justify an appeal to the Postgres CoC committee because the Code of Conduct addresses an individual’s actions, not the organization’s, so I will not appeal. I am not urging anybody to take any legal action against anyone.

Instead, I am doing the only thing I can: speaking as a person and addressing the people—the individuals. And that’s what I will say: I am deeply disappointed and disillusioned with the extreme cynicism exhibited by the PostgresPro leadership.

The worst case is, of course, that PostgresPro and its leadership fully wholeheartedly support the Putin regime’s imperialistic, expansionist, and genocidal aims in Ukraine. If we assume that this is not the case– a generous assumption, given public posts by leadership celebrating the annexation of Crimea, among others–  the best case is cynicism, which allows them to talk out of both sides of their mouth. To work with and be complicit in the crimes of the Russian government and to expect to still participate fully in the global community with no diminishment to their standing or the respect afforded to them. Not only this but to boast that they are too important to Postgres to suffer any sort of consequences. 

It is not enough to be “pure of heart” in secret if your actions are indistinguishable from those of someone who sincerely supports the war. Cynicism lies in the expectation that your public statements will be treated as sincere by the state but insincere by others in the global community.

People make a community, but it’s the individual moral decisions that truly shape the environment. When deciding whether to include or exclude the representatives of specific organizations from Open Source events, please remember: your choices carry weight. Does it feel right to you?

As for myself, I will repeat my earlier statement: I regret that I was not vocal enough before, and I am determined not to be silent. I do not expect everyone to agree with me, but I wanted to identify my position as clear as possible.

Leave a comment

Filed under Uncategorized

Why I Stand with Alicja

My support of the petition for the removal of PostgresPro-affiliated talk from PG Day UK raised some questions, both from community members who were unaware of the situation and those who were very well aware but disagreed with my point of view. This being said I wanted to write some extended comments and explain my position.

Ten years ago, when the Russian government announced the “import substitution” policy, urging the use of only Russian “native” products and technology, the PostgresPro leadership chose to exploit this situation. Their press releases issued in English became utterly different from the ones issued in Russian. The Russian ones condemned “rotten Western products” and praised the “native Russian DBMS PostgreSQL.” These claims opened an avenue to receiving multiple government contracts, including contracts with not only Gazprom but also with the State Treasury and the Ministry of Defense.

Back in 2014, the company praised the annexation of Crimea and continued to support the Russian war with Ukraine when the conflict transitioned to the active phase in 2022. I want to reiterate that I do not intend to penalize people for their citizenship or to judge the character of any individuals. This is about an organization whose leaders willingly support state terrorism and who have profited from the patronage of the state and supporting the state’s activities. I firmly believe that silence is complicity, but in this case, we are talking not only about silence but also about vocal support on multiple media platforms.

In addition, I would like to point out that every time any prominent community member participates in a Postgres Pro conference, these events are publicized and used to legitimize the organization. It is interpreted as “the world recognizes us.” The same goes for accepting Postgres Pro talks at community conferences. Participation is seen as not only silent but actually explicit approval of the activities of PostgresPro. The Postgres community should take the example of the International Olympic Committee and as a minimum, remove company affiliation.

In conclusion, I want to add that I do not consider myself guilt-free. As a part of the generation that didn’t demand lustration and let the former communist leaders climb back to power, I am also responsible for atrocities happening right now. I regret that I was not vocal enough earlier, and the most minor thing I can do now is not be silent.

1 Comment

Filed under Uncategorized

Five Months Later – My Talk at SCaLE

That was my first presentation of the Security talk, and I hope it won’t be the last one! Still hope, despite many rejections 🙂

Leave a comment

Filed under events, talks, Uncategorized

July Chicago PUG Recording

We had a great meetup on July 16! Shaun Thomas gave an amazing talk, and we didn’t expect anything less from one of our favorite speakers! Shaun joined Chicago PUG from the very start, and over 10+ year he has presented at least 10 times, if not more!

The title of July 16 talk was An In-Depth View of pg_timeseries, A Postgres Time Series Extension, and I am happy to share the recording! Enjoy!

Also, I am copying Shaun’s comments from the meetup page, with links to his slides and blog posts:

Here are the slides in PDF form for the talk:

https://drive.google.com/file/d/1O9jsqbEta7UiIJD_ld9OwkoTMwxRd6n8/view?usp=sharing

And as promised, here are links to blog posts I mentioned while doing the talk:

https://bonesmoses.org/2016/pg-phriday-irrelevant-inclinations/
https://bonesmoses.org/2024/pg-phriday-wanton-animal-cruelty/
https://bonesmoses.org/2024/pg-phriday-dirty-postgres-rag/
https://bonesmoses.org/2024/pg-phriday-brand-new-rag/

It was great meeting everyone, and I hope you keep using Postgres! 🙂

Leave a comment

Filed under Uncategorized

May and June Meetups Recordings

I am happy to report that we solved most (hopefully all!) of the technical problems related to switching to the webinar format, and we now have recordings for the last two meetups available!

Enjoy!

May Meetup
June meetup

Leave a comment

Filed under Uncategorized

Chicago PUG welcomes Chicago Open Source Data Infrastructure Meetup!

It was amazing! I am so thankful to Matty Stratton for suggesting the idea of the joined meetup and for coming and presenting! Also, thankful to Jerry Sievers for sharing the tips that nobody else knows!

And I am so-so thankful to all attendees for coming! We had a huge group tonight; we could almost have a conference 🙂

Leave a comment

Filed under Uncategorized

Why I do not want to work in a startup anymore

For those who have known me long enough and heard me saying, “I want to do one more startup before I retire,” quite often, the title of this post would be at least unexpected. And I won’t swear by it. My life had taken so many unpredictable twists that the only thing I learned very well was “never say never.”

However, recently, I was saying something different: “I hope to stay with this company until I retire.” And once again, I won’t swear by it because life is unpredictable, but I started thinking about what changed my mind so drastically.
It is not only that I enjoy working with everybody in this company (I was fortunate to have wonderful co-workers everywhere I worked), but most of the problems I have to solve here.

A startup’s appeal is that you come to uncharted territory and build everything from scratch. There is nobody to blame for some suboptimal decisions made in the past. You take s responsibility for making these core decisions because you believe your approach is the right one. And if it does not work as expected, you are the first person to notice and the first person to take responsibility for a wrong decision. When you see the revenue growth, you can link it directly with what you’ve done, and if you don’t, you know who to blame!
However, there is a twist. As I’ve said before, I do not enjoy consulting because you never know “what happens next.” You presented a customer with your suggestions, and you do not even know what happened after, whether your suggestions helped in the long run. Moreover, sometimes you do not even know whether they were implemented!
Surprisingly, working in a startup, you can experience something similar. Except for some rare cases, you start with small data volumes, a small client base, and a not-so-busy website. You can implement technology solutions that would be pretty elegant and work perfectly for a while. They may still work perfectly when you have a hundred times larger database and a hundred times more customers. And you are unlikely to reach the volumes of, say, the Bank of America by the time your startup cash out, or you become bored, or something less optimistic happens.

I found immense satisfaction in solving problems of a different magnitude than before. For example, I always tried to productionize and automate database-related tasks. Still, the need for such automation is apparent when you have hundreds of databases to supervise. You need to secure some policies programmatically rather than just tell people, “don’t do that!”
Or take my recent bitemporal partitioning project. The bitemporal model performs so well, even on very large data volumes, that I never had a reason even to start thinking about how partitioning should look like. And just three months into working in my new company, I have this new addition to pg_bitemporal.

The changes might not be as rapid as in the startup environment, but I can still see the impact of my work. And that’s what I like most.

1 Comment

Filed under Companies, Uncategorized

Developing Modern Database Applications – A Book Review

Reblogging to share on LinkedIn

Hettie D.'s avatarThe World of Data

Some time ago, I was asked to review a bookDeveloping Modern Database Applications with PostgreSQL. I was happy to submit the review because I really like the book, and I think it fills in many gaps in the technical literature.

I think it happened to many of us: you start something new, you read documentation, and you are still left there with an embarrassing question: OK, so how should I do thisfor real? This book provides enough instructions to spare you from these questions: all the steps are listed, and there are plenty of pictures so that you can be reassured you are doing the right thing. That’s especially important for smaller groups of developers, which often do not have enough expertise in all areas, but still, need to jump-start their development.

Below is my Amazon review.

View original post 502 more words

Leave a comment

Filed under Uncategorized