# PostgreSQL session at Percona live - deep dive into internals **URL:** \ **Category:** PostgreSQL General Discussion\ **Created:** [June 1, 2021, 8:14pm UTC](https://forums.percona.com/t/postgresql-session-at-percona-live-deep-dive-into-internals/10661 "2021-06-01T20:14:26Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![PA\_l](https://avatars.discourse-cdn.com/v4/letter/p/74df32/32.png) [@PA\_l](https://forums.percona.com/u/PA_l)\ **Post date:** [June 1, 2021, 8:14pm UTC](https://forums.percona.com/t/postgresql-session-at-percona-live-deep-dive-into-internals/10661/1 "2021-06-01T20:14:26Z")
Hi all, There was a session at Percona live that I watched - didn’t note down speaker or topic… (Doh, slaps forehead…). Anyway, it was this guy who went really down to the internals of PG - looking at records at the byte level and getting hex dumps and the like. I’d really like to watch it again if anybody has seen it and has a link that would be great! TIA and rgs, Pól… ---
**Author:** ![daniil.bazhenov](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/daniil.bazhenov/32/62_2.png) [@daniil.bazhenov](https://forums.percona.com/u/daniil.bazhenov)\ **Post date:** [June 2, 2021, 6:06am UTC](https://forums.percona.com/t/postgresql-session-at-percona-live-deep-dive-into-internals/10661/2 "2021-06-02T06:06:51Z")
Hi, welcome to the forum. Glad you enjoyed Percona Live. I don’t know what specific talk you’re talking about, however you can find the session on the schedule (Perhaps by speaker or title) > **[Percona Live Online Schedule](https://perconalive.sched.com/overview/type/PostgreSQL)** > > Check out the schedule for Percona Live Online And then find the video recording on the website > **[Percona Live Online 2021](https://www.percona.com/conferences/percona-live-online-2021)** > > The biggest open source database conference in the world. 196 SPEAKERS, 206 SESSIONS AND THOUSANDS OF ATTENDEES. All sessions will also be published on YouTube Percona > **[Percona](https://www.youtube.com/c/percona/playlists)** > > Welcome! Percona's YouTube channel features technical videos, webinars and screencasts about all things MySQL and MongoDB. With more than 3,000 customers worldwide, Percona is the only company that delivers enterprise-class solutions for both MySQL... ---
**Author:** ![PA\_l](https://avatars.discourse-cdn.com/v4/letter/p/74df32/32.png) [@PA\_l](https://forums.percona.com/u/PA_l)\ **Post date:** [June 2, 2021, 8:32am UTC](https://forums.percona.com/t/postgresql-session-at-percona-live-deep-dive-into-internals/10661/3 "2021-06-02T08:32:06Z")
Привет Даниил и Спасибо! (Hi Daniil & thanks), I found the session thanks: > **[Percona Live Online: Reducing Costs and Improving Performance...](https://perconalive.sched.com/event/io4O/reducing-costs-and-improving-performance-with-data-modeling-in-postgres)** > > View more about this event at Percona Live Online It’s by a Percona engineer - Charly Batista, however the presentation doesn’t appear to be available. Could I try emailing him? Or just generally with an FAO: here? > **[Sales & General Inquiries](https://www.percona.com/about-percona/contact#us)** > > Percona's experts can maximize your application performance with our open source database support, managed services or consulting. I understood that the presentation would be available after Percona Live. Thanks for any assistance you can provide. Pól… ---
**Author:** ![daniil.bazhenov](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/daniil.bazhenov/32/62_2.png) [@daniil.bazhenov](https://forums.percona.com/u/daniil.bazhenov)\ **Post date:** [June 2, 2021, 8:35am UTC](https://forums.percona.com/t/postgresql-session-at-percona-live-deep-dive-into-internals/10661/4 "2021-06-02T08:35:50Z")
Let’s try to get @Charly_Batista here on the forum ---
**Author:** ![daniil.bazhenov](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/daniil.bazhenov/32/62_2.png) [@daniil.bazhenov](https://forums.percona.com/u/daniil.bazhenov)\ **Post date:** [June 2, 2021, 8:44am UTC](https://forums.percona.com/t/postgresql-session-at-percona-live-deep-dive-into-internals/10661/5 "2021-06-02T08:44:44Z")
I think the video is coming soon, I’ll send a link when I see it. Also, I wrote to Charly, maybe he’ll come here and answer questions. ---
**Author:** ![PA\_l](https://avatars.discourse-cdn.com/v4/letter/p/74df32/32.png) [@PA\_l](https://forums.percona.com/u/PA_l)\ **Post date:** [June 2, 2021, 9:03am UTC](https://forums.percona.com/t/postgresql-session-at-percona-live-deep-dive-into-internals/10661/6 "2021-06-02T09:03:11Z")
Hi again Daniil, и cпасибо очередной раз (hope my Russian is correct)! That’d be great - thanks. I’ll keep an eye on the forum and see what happens. Talk soon, take care, Pól… ---
**Author:** ![Charly\_Batista](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/charly_batista/32/1242_2.png) [@Charly\_Batista](https://forums.percona.com/u/Charly_Batista)\ **Post date:** [June 3, 2021, 12:45pm UTC](https://forums.percona.com/t/postgresql-session-at-percona-live-deep-dive-into-internals/10661/7 "2021-06-03T12:45:41Z")
Hello @PA_l, I’m glad that you found the session useful. I don’t know when the recordings will be available, this is done by the conference organizers, but if you have questions about the topic or the presentation itself I can try to answer them. Regards, Charly Batista ---
**Author:** ![PA\_l](https://avatars.discourse-cdn.com/v4/letter/p/74df32/32.png) [@PA\_l](https://forums.percona.com/u/PA_l)\ **Post date:** [June 3, 2021, 1:12pm UTC](https://forums.percona.com/t/postgresql-session-at-percona-live-deep-dive-into-internals/10661/8 "2021-06-03T13:12:14Z")
Hi Charly - and thanks for getting back to me. Unfortunately, I watched the session thinking that I’d get the recording in a couple of days - max, that’s what they (conference people who were answering questions during the session) were saying - so I thought that’d be fine. I know the talk was about record organisation and you took a deep dive to look at how stuff was stored on disk - to the point of individual field boundaries… I was just trying to get the general gist of the talk without taking detailed notes. I suppose that any references that you may have to other URLs on this topic would be great - where did you get the info? Also, maybe you could email the organisers (it is Percona guys who were running it, right?) telling them that there are people looking for the presentation - that would be good too. I’m exploring this very topic at the moment and I would like to get the commands that you used to get down to the (nitty gritty 🙂 ) of the disk &c…, but I don’t have any specific questions or commands at the moment - just remember thinking that I must go through that slowly in my own time! I enjoyed it anyway, and hope to have the opportunity to see it again. Best regards and obrigado novamente, Pól… ---
**Author:** ![HamidAkhtar](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/hamidakhtar/32/3688_2.png) [@HamidAkhtar](https://forums.percona.com/u/HamidAkhtar)\ **Post date:** [June 8, 2021, 9:27am UTC](https://forums.percona.com/t/postgresql-session-at-percona-live-deep-dive-into-internals/10661/9 "2021-06-08T09:27:19Z")
The recorded session is now available here: > **[Reducing Costs and Improving Performance With Data Modeling in Postgres](https://www.percona.com/resources/videos/reducing-costs-and-improving-performance-data-modeling-postgres)** > > During this talk we will explain how PostgreSQL organizes the data internally, how the Free Space Map (FSM) works and how we can reorganize the data model to take advantage of data alignment inside bl ---
**Author:** ![PA\_l](https://avatars.discourse-cdn.com/v4/letter/p/74df32/32.png) [@PA\_l](https://forums.percona.com/u/PA_l)\ **Post date:** [June 9, 2021, 8:11am UTC](https://forums.percona.com/t/postgresql-session-at-percona-live-deep-dive-into-internals/10661/10 "2021-06-09T08:11:42Z")
Thanks for that guys - really appreciate that this was done - it’s good to see that Percona is a company which is interested in more than just simply gouging revenue out of people - you are interested in spreading knowledge about Open Source also! Kudos! Also @Charly_Batista @daniil.bazhenov Pól… ---
**Author:** ![Charly\_Batista](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/charly_batista/32/1242_2.png) [@Charly\_Batista](https://forums.percona.com/u/Charly_Batista)\ **Post date:** [June 9, 2021, 7:25pm UTC](https://forums.percona.com/t/postgresql-session-at-percona-live-deep-dive-into-internals/10661/11 "2021-06-09T19:25:11Z")
Thanks for the kind words @PA_l . You can find the presentation files on github here [GitHub - elchinoo/pl21: Percona Live 2021 presentations](https://github.com/elchinoo/pl21) Regards, Charly Batista