Category Archives: news

New features are available in the bitemporal repo – and I am so happy about it!

I Really hope that most of my follows know something about the pg_bitemporal project, because if you didn’t hear about it, you won’t be able to share my excitement!

We started to build our bitemporal library for PostgreSQL about four years ago, it was merely a “proof of concept”, and Chad Slaughter, who initiated all this work, knowing my work habits way too well, was re-iterating again and again – do not optimize it yet!

Well, I didn’t, but then I’ve joined Braviant Holdings, and a year later I was granted a permission to use our bitemporal framework in production. Some of the performance flaws became apparent even during the test run, and I was able to fix them. Later, while we were using it in production more and more, I’ve come up with new functions, UPDATE_SELECT and CORRECT_SELECT, since we actually needed them, and since the bitemporal operations were supposed to behave the same way as regular database operations.

About three weeks ago we had a very important release, which along with addressing multiple business needs, included some significant changes on the technical side. One of the consequences was, that it significantly increased the traffic on our new planform, and as a result we started to see some timeouts.

Although these timeouts were pretty rare, we saw them as a problem. I personally pledged the system will remain scalable, and now I couldn’t just go with “bitemporal updates are slow”. Yes, the execution time was at 2 to 3 seconds most of the time, but sometimes it would spike, and our microservices have a hard timeout at 10 seconds.

Some time ago I’ve already mentioned in this blog, how thankful I am for those timeouts! Nothing else foster innovation more than a necessity to address performance problems immediately, because they have a direct impact on production.

This time around I was 99.9% sure that the periodic slowness happens during the remote query, which is a part of the problematic function. Turned out, though, that this 0.01% was the case, and together with our DB team we were able to determine, that the problematic statement was the last UPDATE in the bitemporal update function. If you’d ask me a week before that, I would say, that I am not going to address the bitemporal performance for the next several months, but I had no choice.

Thanks to Boris Novikov, who helped me immensely in testing and verifying several different approaches, and eventually identified the best one, and to Chad Slaughter, who was merging my commits from 7-30 AM to 9-30 PM, so that the master branch of the bitemporal library would have the latest updates by the time of the release, and thanks to our amazing QA team, who had to run and rerun tests that day multiple times, the new bitemporal functions are now on place. Not only for Braviant Holdings, but for the whole community.

I would also like to mention, that since I was already changing the functions, I’ve fixed one long-overdue issues: all functions have versions, which are PG 10 compliant. We’ve left the old versions there, because some of the are used in the existing production systems but if you are just starting, you can use the new ones.

Check it out at https://github.com/scalegenius/pg_bitemporal

Advertisements

Leave a comment

Filed under news, research, SQL, Team and teamwork

The 2Q PGCONF program just announced!

Hi Chicago! I am extremely excited to share with you the program of the upcoming 2Q PGCONF! After the last year’s success the organizers decided to add a whole day f training to the conference.

So, here is what you need to know: the training schedule is here. The talks schedule is here. Exciting news for my company – two talks from Braviant Holdings were accepted! I think it tells a lot about how our company foster innovation and invest in employees professional development.

And now the important dates to remember: the training is on Tue December 4, and the talks are on Wed December 5, and October 14 is the last day of the early bird registration!!!

And finally the last thing. The Chicago PostgreSQL User Group meetup will be next week, Wed Oct 17, featuring Shaun Thomas. Please come and have a sneak peek of the conference!

Leave a comment

Filed under Companies, events, news, talks

May Chicago PUG announcements

We had an amazing attendance at Chicago PUG meetup last week. I was looking at the audience and thinking about the first Chicago PUG in the Braviant Office in January 2017. Sixteen meetups later – this was our last meeting in this building. In less than a months our company will move to the new home, and Chicago PUG will also have a new beautiful space for the meetups.

These past almost eighteen months were quite a journey, and a really exciting one, thanks to the generous sponsorship of PgUS, thanks for amazing speakers, including Joe Conway, Bruce Momjian, and many other outstanding researches and practitioners from the Postgres community, and last but not least – thanks to all of the active participants.

We are committed to continue making each Chicago PUG meetup a memorable event, and as a part of this effort we are going to Introduce Chicago PUG 2018 awards:

 

  1. Best presentation award (voting will take place in December)
  2. Participation award: the company which will have the largest total number of participants in May – Nov meetups
  3. Diversity award – the talk presented by somebody from under-represented demographics.

With this in mind – please join us at our new address 33 N. LaSalle Floor 8 on June 26 2018 at 5-30 PM.  The RSVP link is here.

Leave a comment

Filed under Companies, events, news

BuiltinChicago

Today’s news  made me proud of our company yet again: Braviant Holdings was featured in  Built In Chicago’s 50 Startups to Watch in 2018! 

Today I could not stop thinking about the day when we moved to this office – it was juts 15 months ago, and there were only nine of us, and looking at the empty office space we would find it hard to imagine that at some point all this space will be filled!  But here we are – and we continue to hire.

We are hiring for all possible IT positions: UI/UX, App Developer, DB developer, QA, BA. We have a great team already, and we hope that each new person will add a significant value.

Let me know if you are interested 🙂

Leave a comment

Filed under Companies, news

We are live!!!

This happened yesterday. And immediately after “this” I’ve realized I am so tired – I could not post even a paragraph.

For the past several months the only thing people have heard from me was – “I am busy”. And I was. And yesterday our new product has been launched. Our new website went live, and a first couple of loans got through, and the first loan was funded.

For a couple of our team members that was the first real product launch in their lives. Not for me, but it’s definitely the first time in my life when not only all database design and database code is written by me (or drafted by me), but also everything is based on the new technologies, which were developed with my participation

the other day one person who’ve known me fora while asked me, whether I’ve accomplished everything in my life.

It sure feels pretty close to that :). That “I have nothing left o wish for” – all my wishes have become true. But now comes the next phase – life have to prove, that all the things I believe are scalable, durable, flexible, efficient – indeed are.

I am always saying: a database is a service. Nobody from the “outer world” can see all these cool things. The only thing people will see will be (hopefully!) fast response.

But you know, what’s even more important than “all wishes coming true”? That’s our team, In my 34 years in industry I am positive that’s the best team I ever worked with,  with each and single person being cooperative, flexible, opened to trying new things, diligent, attentive to details… and the list goes on… I’d just summarize it – each and single person in the team understands what the word team means:).

A picture from the launch:

Leave a comment

Filed under Companies, events, news, Team and teamwork

2Q PG Conf 2017 in Chicago

This conference took place here in Chicago on November 9, and I just loved everything about it! I will try not to repeat myself, since I’ve already mentioned about a million times what a great idea is it to have a one-day conference which is geared towards the local Postgres users. I am not sure to which extent I really helped this conference to be a success (although the organizers firmly believe I did!), but in any case it turned out ot be exactly what I was hoping it to be.

Great venue, great talks (and I do not mean mine :))

Continue reading

1 Comment

Filed under news, People, talks

Bruce Momjan’s talk at PG Open will be replayed in Chicago – stay tuned!

Once again, I did’t write more about PG Open, although I had grand plans. But there were so many interesting talks, that I am still going to write about them, even though it’s already 3 weeks past the conference.

One talk I really enjoyed, was Bruce Momjian “The Window Magic“. You can find the presentation here.

That’s what I really liked about it. Window functions are hard. Seriously. This is one of those things, where you know there are options and answers to everything, but figuring out how to do this takes so long that you almost do not want to do this. What I absolutely love about this presentation is the fact, that it starts from the very basic example, and then adds one feature after another, and each time it is one easy – and logical! – step. And the amazing thing is, that Bruce manages to make sense out of literally each and single option, and they all make sense! None of them looks artificial or “why anybody would want to do that?”

Granted, it won’t be me, if I won’t have any comments :). The comment I had here was, that people should be warned that the window functions are resource consuming. The moment you really figure out this magic, you want to use it everywhere, even instead of min/max with group by! And the execution time will be very different in this case.

And now the best part – Bruce graciously suggested to bring his talk right here to Chicago!  Thereby we are moving the November PUG date – it is now scheduled for November 8.  Please RSVP to this event here.

Leave a comment

Filed under news, People, talks