[MUSIC]
CLAIRE: I think next we move on to do our wrap up session.
JELTE: Yeah, we do.
CLAIRE: We're running a little bit late.
We're supposed to end at the 30 minute mark,
that's 10 minutes from now.
Our producer has graciously agreed
to allow us to run five or 10 min late.
For those of you in the audience,
we just want to share
some information and reminders that are useful.
There's some videos that we want to roll too,
that give you a sneak peek an
even better sneak peek into those on-demand videos.
Let's see, what do we have here?
Oh, the reminder about the survey.
If you've ever given a talk,
you know how valuable that feedback is on your talk.
Please, as a gift to the speakers and
the organizers for this virtual event,
like we would love
your feedback surveys open till next Friday, the 28th,
end of day, anywhere on Earth, 11:59 PM PST.
Then Jelte, whatever you want to say about the Discord.
JELTE: Go there, ask questions,
talk to people, or just read what other people write.
You can lurk as much as you want. It's fine as well.
CLAIRE: Lurking is okay. These are
the talks that we just reviewed and I just popped
the livestream playlist URL on the screen again,
so you can go watch them,
or screenshot them or send them to
colleagues even before we publish.
Then I just wanted to remind everybody that
Boriss who did the storytelling
is along with Alvaro Herrera going to be
a guest on Path To Citus Con Wednesday, May 3rd.
It's a really cool format.
We stole the idea from
Bryan Cantrill and Adam Leventhal and folks that Oxide Computer
who have been doing these live shows on Discord where
there's a voice conversation
that ends up getting turned into a podcast recording.
But then in parallel,
there's this live text chat.
Everybody in the audience has a chance to participate,
drop-in links, add comments,
and so you're interacting and experiencing
the event on two levels at once and it's just a ton of fun.
Our first two episodes were
pretty popular and we're going to do it again.
This one will be about why giving talks
at Postgres conferences matters,
which seems appropriate for me to have mentioned here.
Is that too much of a sales pitch?
I'm just so excited about this.
JELTE: No, it's fine Claire.
It's a bit of a sales pitch but it's okay.
CLAIRE: We already mentioned the Americas live stream you can watch.
Should we roll some of these on-demand?
JELTE: Yeah, let's do it.
CLAIRE: Let's roll the first one on Postgres performance and security.
[MUSIC]
HAKI: But in fact, I'm going to show you different,
hopefully exciting ways that you don't know about to,
index UUIDs and PostgresSQL.
HANS-JÜRGEN: If you are a traveling Postgres consultant like me,
so we see that often.
a lot of performance can be gained by out smarting people.
CHELSEA: I'm going to be talking about Postgres table bloat.
But the overall idea of this talk is discussing the transition
from doing Postgres on 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.
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.
[MUSIC]
JELTE: Yeah, I know this sounds amazing
and I'm a huge security nerd myself,
so I am definitely going to watch Taras's talk.
CLAIRE: Yeah, I think we could spend
five minutes talking about each one of these.
The thing for me that's so cool about being involved in
Postgres conferences is this is how I've met some of these people.
They don't work with me on the Citus team or at Microsoft.
Well, other than Samay on this grouping,
these are all people I've met at conferences.
The Postgres community it's open and it's global,
and it's pretty fun.
I think I have more slides here that we're supposed to go through.
Let's see if I can click into them.
I did want to say thank you to
the talk selection team for all of those proposals.
I'm not trying to think myself, no.
That that's not the point,
but, you know, Alicja,
Aaron, Charles, Marco,
this took a lot of time.
It was a big lift. There were a lot of submissions
and I really wanted to just give them a shout out.
JELTE: Thanks to everyone.
CLAIRE: Then here SWAG,
the code is on the screen.
SWAGBAG. The URL is on the screen.
If you're here and you haven't had a chance to go do that.
This activity book is actually cool. I have it here.
I don't know, it's fun for kids,
and it's fun for adults and stickers.
I just want people to be able to benefit
from this so I wanted to mention it.
Because I think I'm not sure if the
cutoff I don't think it's like this minute.
I don't think it's the moment the livestream ends,
although it could be, so do it now.
But it's certainly going to be today,
probably within the hour or something,
but maybe before this live stream ends.
What else do we have here?
Jelte that we wanted to cover.
I think we oh the sticker packs
too. That is a different code, so STICKERS,
so if you want to enter for both,
you got to enter twice using the same URL, the different codes.
JELTE: You're allowed to do, that's fine.
You can enter to both of them. That's totally acceptable
CLAIRE: You don't have to JELTE: You don't have to, but you are allowed.
CLAIRE: It's good that you're giving people permission Jelte,
because they might not have been sure and now they are.
Let's roll the next video that gives
some sneak previews of some of these on-demand talks.
These are our talks all about Postgres on Azure.
[MUSIC]
LUCAS: Hey Lucas here, and I'll present to you how I autoscaled
a Cosmos DB 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 are expecting or already are running
into scalability issues with their database,
and want to scale out with distributed PostgreSQL.
ADAM: Today, we are going to talk about
multi-tenant software as a service applications
on Azure Cosmos DB for PostgreSQL.
ALICJA: It's built upon 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: Today's focus of the talk is to discuss some tools,
recommendations, and best practices of how to reduce
cost on Azure Database for Postgres 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.
CLAIRE: Those are all good talks.
I think I've seen all of them so far except for Adi's.
Adi is the one who gives the Oracle to
Postgres partitioning strategies talk.
But I have to say,
any talk that features Grafana in a demo,
I'm always a fan.
JELTE: I use Grafana a lot at my previous company,
and it's an amazing software.
CLAIRE: Yeah, so thank you,
Lucas for putting that together for us.
Let's see. I promised somebody I would put this slide up here.
Speaking of Azure Cosmos DB for PostgreSQL,
which I call Citus on Azure because I work on Citus open source,
but the service name on Azure is Azure Cosmos DB for PostgreSQL.
We had a big launch around that last October,
and this training module,
one of my teammates contributed to it, Joe Nelson.
It's supposed to be pretty good
for anybody who's trying to get started.
I promised I would drop this up there with that short URL,
although it's a long URL.
But anyway, that aka.ms URL for anybody
who's looking to get started using Citus on Azure.
So there, job done.
We have another trailer.
This one is from people who are either Citus open source users,
are in the ecosystem,
in Alvaro's case or
Onder obviously you work very closely with him.
He is the second from the right. Let's roll this one.
ALVARO: This talk we're going to discuss in
a little bit why you want to run a database on 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, cybersecurity 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 have been here since the early days,
and through a lot of our growth in 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.
JELTE: It's always great to hear stories from people using
Citus and even the problems they run into.
They're not so nice to hear but they are good to
hear so we know what to change.
CLAIRE: I'm trying to find the banner that I have
that goes to all these on-demand talks. Here we go.
If you want to watch any
of the on-demand talks that we're showing,
you can get to there from the schedule page.
This URL takes you
to the schedule page with the on-demand tab opened,
and there's YouTube embeds there
for every single one of these talks.
I don't know. I do a lot of my learning on the weekends.
I tend to sleep in on Saturday mornings and then go
for a hike with my husband and then try
to read a blog or watch a video or something.
There's plenty to keep me busy and
hopefully everybody else moving forward,
but definitely go check those out.
I think we have one more video to roll in a minute.
This is just the Citus GitHub
repos screenshot that I put up there.
Seemed relevant to the talks that we just looked at.
I know you spend a lot of time here Jelte
because you're pretty active.
JELTE: Yeah, I push lots of commits,
and review lots of PRs.
I know this page very very well.
CLAIRE: Yeah, that's where you live and work.
The next collection of mini previews of the on-demand talks,
these are all Postgres ecosystem talks, Postgres community talks.
Yeah, let's see what it is.
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: 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 it what we think it's a very robust,
document database and event store solution.
NAZIR: Today, I will talk about in
depth guide to the Postgres' new CI.
I will explain how to use the new CI
PAOLO: In this talk, we'll 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.
JELTE: Yes, there are some very interesting too.
Basically the whole playlist is on
my to-watch list in the time I have after this.
CLAIRE: Jelte, this is
actually the second time I've co-hosted something with you.
We did a release party?
JELTE: Yeah. That was also, I don't know,
last December or something.
CLAIRE: 11.2?
JELTE: I think it was around December.
It was also very fun.
CLAIRE: Are we allowed to say anything about Citus 11.3? It's happening.
JELTE: Yes, it's very close.
We sort of have all the code, pretty much ready.
Citus Con was a bit like,
we need to focus our efforts here for a bit on that.
The next thing to focus our efforts was
actually doing the final release of 11.3.
It should be out in like a few weeks, like two-ish
CLAIRE: Anybody who's on the Discord,
obviously Rob Treat was the co-host for the Americas
livestream earlier today,
depending on your perspective on time.
He's awesome and that was so much fun.
But those of you who are on the Discord right now,
who are watching, by all means,
let us know if Jelte and I should
co-host something else together in the future,
like perhaps, maybe the next
livestream or not the next livestream,
the next release party.
Let us know. Uh oh, Jelte,
we're going to be in trouble if nobody says anything.
What does that mean, what are we going to do?
Before we end I wanted to throw
the SWAGBAG and STICKERS codes up there with the URL.
If you haven't yet gone to request those,
it'll get shipped to you.
Your addresses will be treated very
confidentially and thrown away afterwards.
Again, there's that invitation to join
us on the back channel on Discord.
Even though this livestream is ending,
our speakers are still going to be there later today,
and probably tomorrow and
now obviously there'll be speakers popping in,
who are on-demand speakers as well.
Feel free to drop your questions there.
It's very asynchronous and that's cool.
But hopefully they will see it,
and when they get there,
they will get you a reply.
Jelte is there anything else that you want to
talk about in terms of closing remarks?
I put the survey URL on the screen,
because I think that's really
important and it's a gift that you can give.
We're happy to give the gift of stickers and socks and things,
but we would love your feedback.
JELTE: I think we are basically done,
and I want to thank everyone that watched,
because we're doing this conference for people to watch it.
Hopefully you enjoyed it and I'll see you next year.
CLAIRE: Long live Postgres,
the world's most advanced open-source relational database.
Awesome. Thank you, see you next year.