Lviv JavaClub [Event 310] PostgreSQL store by Oleksandr Belinskyi

Review PostgreSQL storage
by Oleksandr Belinskyi @ Java Software Engineer at Lohika / oleksandr-belinskyi-93...
Code from the event: drive.google.com/file/d/1sL3t...
Event details: www.javaclub.lviv.ua/2024/02/...
Agenda:
00:00 Intro
00:38 Where does Postgres store data?
03:31 Base terminology
04:24 Heap File structure
07:10 Dive into binary realm
08:19 Table structure in binary file
18:04 How do indexes work in Postgres?
22:36 How are indexes stored on a disk?
23:39 An index in PGAdmin
37:36 An index in binary file
44:48 Q&A
53:20 - join us #javaclub
Lviv JavaClub new t.me/LvivJavaClub
Follow #javaclub: / @lvivjavaclub
Web site: javaclub.lviv.ua/
GitHub: github.com/lvivJavaClub