[MUSIC]
>> CLAIRE: Now it's time to go to the wrap-up.
And it's you and me. Our wrap-up is supposed to be, like, 25 minutes,
but we're going to have to go fast, Rob.
>> ROB: Yeah, you know, I was going to say, like, I can't tell if it was
a long day or like a short day,
because it seemed like it went by pretty quick. But that's good.
>> CLAIRE: It did go by really quick, and
especially paying attention to the chat
and trying to pay attention to the talks.
And forget about live tweeting,
thank goodness that other people are out there doing that.
So, we have a couple of things that we wanted
to cover in the beginning. So let's see.
The first is just that reminder that there's
a survey and you can quickly scan that QR code.
You can enter the survey feedback multiple times.
So, if you haven't watched all the talks yet,
you want to watch some of the on-demand ones or whatever,
you can do it multiple times until it
closes next Friday, so very useful.
>> ROB: Vote early, vote often.
>> CLAIRE: Vote early, vote often, that works.
I feel like it's a broken record.
I've mentioned the Discord umpteen times. So.
There's a word for when you say a word so many
times that it loses its meaning inside your head.
No. And actually that word was on a Ted Lasso episode recently,
but that's another story and I just can't recall what it was.
But anyway, I have said the word Discord so many times today.
But there is kind of a fun back-channel there for those who want to join,
and it's going to continue throughout the rest of the day.
Wow, big thank you to all of these speakers.
>> ROB: Absolutely.
>> CLAIRE: This is pretty cool. And I have
the URL showing for the livestream playlist.
Citus Con livestream playlist right now,
and that's why I pop this up there.
And then if you want to mark your calendar,
I want to make it easy for you if you want
to go to all or part of the EMEA livestream.
Because who knows where you are in the world,
you might be watching this in replay in
a couple hours and maybe you live in Europe.
So the link in the upper right corner,
aka.ms/cituscon-emea, that gives you
an easy way to drop something in
your calendar for the EMEA livestream tomorrow.
You'll be asleep, Rob.
>> ROB: I hope so. I mean, I do want to watch this.
I will definitely watch the replay of it,
but I don't think I will watch it live.
>> CLAIRE: Got it.
>> ROB: Something will have gone really wrong if that happens.
>> CLAIRE: So, on-demand talks, there's 25 of them.
>> ROB: That's a fair number of talks. But they're, well, I don't know.
I assume they're all really good
because I've looked through the list,
I've been trying to also peruse that along with
these other things we have going on today during the livestream,
I was like looking through that list of talks and seeing what
was there and I'm really excited.
Actually, I will be watching some of those
tonight before things happen tomorrow, so, for my tonight.
>> CLAIRE: Well, and you gave a really interesting on-demand talk
last year and I know that, you know, those views,
they don't all happen on the day of the event, right?
They happen over time.
There's a whole long tail.
And so, the good news is people can consume it at
a time that's convenient to them.
But obviously for anyone who is interested in a particular topic,
if they hop in there today,
tomorrow, then they can ask questions on the Discord.
And actually, it's a little bit easier to reach the speakers,
unless those speakers are at KubeCon,
a few people are distracted with KubeCon.
>> ROB: There are other conferences going on?
>> CLAIRE: There are other conferences, I know.
There's a Microsoft MVP Summit
too, for people who are involved in that.
So we have a couple of promo videos and I wanted to play
that first one that is all about
Postgres performance and security that goes through super super fast,
like, 10 seconds each, for some of
these on-demand talks. So that sounds good?
>> ROB: That sounds awesome.
>> CLAIRE: Okay let's go.
[MUSIC]
>> HAKI: But in fact, I'm going to show you different,
hopefully exciting ways that you don't know
about to index UUIDs in PostgreSQL.
>> HANS-JÜRGEN: So if you are a traveling Postgres consultant like me,
you will see that often a lot
of performance can be gained by outsmarting people, right?
>> CHELSEA: Today I'm going to be talking about Postgres table bloat.
But the overall idea of this talk is discussing the transition
from doing Postgres at a smaller scale to Postgres at scale.
>> RYAN: I'm going to talk to you today about PostgreSQL,
privileges, roles, and security,
and how you can take
better advantage of them within your Postgres installation.
>> SAMAY: The thing I wanted to talk about,
explain the concepts behind tuning high-write workloads for
Postgres and then dive deeper into the specific configurations.
>> DMITRY: I'm DevOps Data technical lead of JFrog,
and I want to share my lecture about
troubleshooting high CPU utilization for Postgres database.
>> TARAS: We will talk about
external attacks, about authentication security,
about data protection,
and also I will share some tips and my recommendations with you.
>> ROB: So much goodness. So here's the thing.
I have to say I got a chance to
look at Haki's slides a little bit and just started like peeking at that.
And that will be one definitely I'm watching tonight
because he definitely goes into things, like
I felt like I've dealt with UUIDs a lot in Postgres.
He does talk about some stuff in there that I don't
think I've seen anyone else actually talk about before,
so maybe I missed it,
but super excited on that one.
And I would also say, like Ryan,
I know has been doing a lot of
advocacy work around roles and grants,
so I'm pretty excited to check that one out as well.
I mean, they all, I think, look interesting,
at least on first glance.
So that's pretty good.
>> CLAIRE: Yeah, I think Ryan gave a talk at
SCALE and you were there as well.
I don't know if you saw that one.
And then Chelsea Dole,
I saw her give a lightning talk at
PGConf EU in Berlin a couple of months ago.
And yeah, she was fabulous.
I went up, introduced myself,
told her all about Citus Con and said
"please submit a talk proposal."
Although, I mean, the talks that get
accepted into Citus Con is pretty competitive.
I think we had like a 27 percent acceptance rate,
so 30...2 invited keynotes obviously,
but 35 talks accepted,
so you can do the quick math in your head
and figure out how many submissions there were.
There were a lot of phenomenal submissions and
it was really hard for the talk selection team.
And in fact, I think I have a slide here if I click ahead.
Yeah, there it was. Just to say "thank you" to
everybody who was on the talk selection team.
Aaron Wislang, Alicja, Marco,
and Charles spent a lot of time
reviewing all those proposals and this conference.
You know, obviously I say every great event starts with great speakers,
but the talk selection team does a lot of work to get us there.
>> ROB: Absolutely. And you know, again,
they made sure not to invite me back.
So, I think the level this year has gone up even more considerably.
>> CLAIRE: Ouch. Don't be self-deprecating.
Swag for those of you who care about swag,
the code is on screen right now as well as the URL.
There are 75 of these being given away in
this livestream time period so if you haven't gone to do it yet.
The activity book is fun,
not only for kids,
but I remember when I first met Melanie Plageman,
it was because she had gotten
the previous version of the activity book at
a Postgres conference and she was enjoying coloring in it. So. Yeah.
>> ROB: Nothing better for when you are waiting on an index rebuild,
than to be able to whip out the activity book, and you know, pass some time that way.
>> CLAIRe: And socks are always cool.
And there's the sticker packs too for those of you who use
stickers either on your laptops like me or on your luggage.
I feel like I'm in an infomercial,
but I know how much people care about swag.
It's like, it's a thing.
>> ROB: Please like stickers.
>> CLAIRE: Yeah, they do. Okay. We have another quick video trailer.
This one is focused more on
the two Azure Database Services for Postgres:
Azure CosmosDB for Postgres.
What I happen to call "Citus on
Azure" because I'm such as Citus open source person,
and then also Azure Database for Postgres Flex Server.
So let's roll this promo.
It's Number 2 unless you want me to do it.
[MUSIC]
>> LUCAS: Hey, Lucas here.
And I'll present to you how I auto scaled
a CosmosDB for PostgreSQL cluster using Citus,
of course, Grafana, and Azure Serverless.
>> SAI: This talk is for multi-tenant SAS companies
who are growing fast.
That is, they're onboarding thousands of customers
and they're expecting or already running
into scalability issues with
their database and want to scale out with distributed PostgreSQL.
>> So today we are going to talk about
multi-tenant software as a service applications
on Azure CosmosDB for PostgreSQL.
>> ALICJA: It's built upon like the community version of Postgres,
so the open source Postgres,
and adds also Citus
extension which turns Postgres into a distributed database.
>> ADITHYA: In this session, I would like to talk about partitioning in
PostgreSQL and how it is similar and different than Oracle.
>> VARUN: So today's focus of the talk is to
discuss some tools, recommendations,
and best practices of how to reduce cost
on Azure Database for PostgreSQL Flexible Server.
>> ANDREY: My talk is about Azure AD Authentication with Flexible Servers.
If you use Flexible Servers or plan to try it out,
this feature will help make
your application connections more secure.
It will save your time
managing credentials and roles. So please check it out.
[MUSIC]
>> ROB: Awesome. I'm not
going to be like every one of these is awesome,
but I will pick one in particular, that I have to say.
So I just, I've seen a lot of chatter about
multi-tenancy deployments in Postgres lately, super hot topic.
It's like it's come back into fashion, I guess.
So that one I'm super interested to see,
because to me I don't know if people always
think of Citus as a multi-tenancy solution.
But clearly it can be used for that.
>> CLAIRE: That means I wasn't doing my job.
I mean, before the acquisition, when we came out with
the "worry-free Postgres" tagline because we just said
that most people only had 30,000 days in their life,
and time is our most precious resource as developers,
as engineers, as people who manage databases.
And so, you're like, you know what, people don't want to wake up at
three in the morning to deal with Postgres database issues.
And so let's focus on worry-free Postgres.
But the other alternative at the time was to kind of really focus
on driving home the point that Citus was a multi-tenant database.
So maybe you don't connect those dots
because we focused on that worry-free angle?
>> ROB: For me, yeah. So the worry-free was
definitely a big part, but also,
I think using it for like statistics monitoring OLAP,
like, that type of stuff,
like we saw in the earlier talk with
JSON and doing that monitoring piece.
To me, I think a lot of people
connect it with that type of a workload.
You know, so that's the reason why I say that.
I don't know if everyone connects it with both sides of that.
It's good for those of those, really.
>> CLAIRE: Yeah, and it is good for both.
And we have tried to serve both of those use cases,
both multi-tenant SAAS and real-time analytics.
But I'm not here to promo the project right now,
although I did just pop up the GitHub,
the GitHub URL on screen.
Okay so, let me see.
>> ROB: I'm going to promo while you're prepping the video.
Go on GitHub. It's all open source again,
and this is, honestly, one of the reasons I'm here, it's all open source.
It's on GitHub. You know, star and watch the repo, all that good stuff.
We'd recommend anyone who's interested in Citus
there's a lot of interesting stuff that goes on over here. So, you know.
>> CLAIRE: Well, you've been a supporter of
the project from far away for a long time
and I really appreciate it because a rising tide floats all boats.
Like I mean obviously, I'm a big fan of other projects.
I love the fact that Lucas did a demo with Grafana,
which I'm a huge fan of and I think it's
good when we support each other,
or recommend, the whole word of mouth thing is
useful in the developer world.
We have a couple of other,
I know we're tight on time because we have to end in just a couple
of minutes and we have two more videos we want to roll.
So let's go ahead and roll video number three, please.
[MUSIC]
>> ÁLVARO: So this talk we're going to discuss
a little bit why you want to run a database in Kubernetes.
How this was done to run
Citus clusters before Patroni 3.0. appeared,
and the most important thing,
how you can run Citus on Kubernetes
today with open source software in a very, very easy manner.
>> SLAVA: In my opinion cyber security applications have
a certain unique set of features and
requirements that are different from other applications.
I also think that Citus database
is very uniquely positioned to
solve many of the challenges
that cybersecurity applications present.
>> MATT: I'm a principal engineer working on
the platform here at Jellyfish,
I've been here since the early days and through a lot of
our growth and our infra choices,
including the move to a sharded database
that we're going to talk with you here today about.
>> DELANEY: The purpose of this talk is
to help get ahead of some of the gotchas
that come up when trying to move to
a self-hosted Citus implementation.
We went through this journey and we'd like to
share some of the interesting technical challenges
that we had to solve.
>> ONDER: Because I frequently get questions
about foreign key support in Citus.
In this talk, I want to clarify some of
the concepts regarding Citus.
>> PAUL: Hello, I'm here today to share with you
some lessons and observations from SafetyCulture's
migration from a managed PostgreSQL service
to our own self-hosted Postgres.
>> ROB: Also another fine slate of talks,
I especially like the one moving
to the self-hosted from the managed.
That's really complicated and I
think will explain to a lot of people what they're getting into. So.
>> CLAIRE: It was a pleasure for me to meet Matt Klein and
Delaney Mackenzie from Jellyfish as they told that story.
Although, also Paul De Audney told a similar story
about moving to self-hosted Citus environment. So.
Obviously, I work at Microsoft
and for people who want that managed service offering,
we offer that, but I love
seeing people be successful with Citus open source, too.
Okay, so, I think we have, let's see,
another video here that some more Postgres community talks.
So let's take a look at these.
>> DIMITRI: I am Dimitri Fontaine,
and I've been contributing to PostgreSQL for a very long time now.
We're going to talk about how to copy a Postgres database,
so, from one server to the other one.
>> HENRIETTA: The concept of storing time with
databases had been popular for very long time.
Pretty much since relational databases come to life.
>> BRUCE: And secondly, the goal of this talk is to talk
about how Postgres can give you
an ideal platform to
use artificial intelligence in your applications.
>> KAREN: We'll set the scene by imagining that you're
the DBA in an organization that needs to implement multi-tenancy.
>> JEREMY: What I'm going to talk about today is
how we've taken PostgreSQL,
a nice, sane relational database,
and how we've twisted it and
molded it and created what we think is a
very robust document database and event store solution.
>> BILAL: Today I will talk about in-depth guide at the Postgres's new CI
and I will explain how to use that new CI.
>>PAOLO: In this talk, we see together how to build web maps from
scratch using Django and PostGIS.
If you are asking yourself
what type of maps we can build with Django,
let's see an example right away.
>> CLAIRE: Okay, that's a lot to unpack.
So there's a playlist, well actually just go to aka.ms/on-demand,
and you can get access,
just go to the schedule page and
all the on-demand talks have YouTube embeds there,
on that on-demand tab.
And so, you can track down any of these and start watching.
So much goodness. I actually
promised somebody I would pop up a slide.
I know we're almost out of time
and we got to talk about what's next.
But I'm just going to pop up this slide like I promised.
For people who do want to learn more about Citus on Azure
this new Azure Cosmos. DB for
Postgres training guide came out a couple of months ago.
I think it was maybe October.
Joe Nelson and my team was involved
in the creation of it, not on my team,
but on the broader team,
and everybody's recommending it.
So if you're new and you want to try this out and get started,
and you want to try it on Azure
versus, you know, just downloading the open source packages,
this is a really good place to get started.
>> ROB: I thought it was going to be a free ketchup slide,
but I guess this is much more useful and
much easier for people who want
to get started and check out some of this stuff, so.
>> CLAIRE: Free ketchup. Okay what's next?
We're a few minutes over time,
I just wanted to flag a couple things.
The first thing is if you're going to
be awake during the EMEA livestream,
which is, you know, not that far away now,
it's happening on Wednesday
at 09:00 A.M. Central European Summertime.
You can add it to your calendar with that URL in the top left.
Let's see. No, is that right?
>> ROB: Yes.
>> CLAIRE: Attend EMEA and then the link on the replay,
the Americas livestream is wrong.
So the link on the replay of the Americas
livestream is what I'm popping
on the bottom of the screen now on a banner.
So sorry about that, folks.
And yeah, the Discord.
Discord. What does Discord really mean?
>> ROB: I think we'll have to save that discussion for another day.
>> CLAIRE: Okay. Rob Treat, thank you so
much for being my co-host and being here.
I know you don't work for Microsoft.
You're not part of the Citus open source project,
but you are part of the Postgres community
and it has been a delight.
>> ROB: It's been my honor. Thank you so much for having me.
>> CLAIRE: Thanks for everyone who joined us and I hope
you check out the rest of the Citus Con talks,
and have a great day.