{"guid":"8f67b425-117b-5575-839f-f6d9e3604f3a","title":"PostgreSQL at low level: stay curious!","subtitle":null,"slug":"ASG2019-117-postgresql-at-low-level-stay-curious-","link":"https://cfp.all-systems-go.io/ASG2019/talk/AXPVZ3/","description":"Have you ever encountered a transient performance issue, that was hard to\ninvestigate only from the database point of view? On top of how many layers of\nabstraction your database is working? What is the difference between running\nyour database on a bare metal, VM or inside a container?\n\nPostgreSQL does not work in the vacuum, it heavily relies on functionality\nprovided by an underlying platform. And sometimes to answer these questions\nabove one needs to step back and look at a problem not only from a database\npoint of view. In this talk we will discuss how to achieve that, how to tame\nsuch tools as strace, perf or eBPF to troubleshoot intricate issues and stay\ncurious.\n\nHave you ever encountered a transient performance issue, that was hard to\ninvestigate only from the database point of view? On top of how many layers of\nabstraction your database is working? What is the difference between running\nyour database on a bare metal, VM or inside a container?\n\nPostgreSQL does not work in the vacuum, it heavily relies on functionality\nprovided by an underlying platform. And sometimes to answer these questions\nabove one needs to step back and look at a problem not only from a database\npoint of view. In this talk we will discuss how to achieve that, how to tame\nsuch tools as strace, perf or eBPF to troubleshoot intricate issues and stay\ncurious.","original_language":"eng","persons":["Dmitrii Dolgov"],"view_count":258,"promoted":false,"date":"2019-09-20T00:00:00.000+02:00","release_date":"2019-09-21T02:00:00.000+02:00","updated_at":"2024-12-18T21:00:02.496+01:00","tags":["asg2019","117","2019"],"length":2262,"duration":2262,"thumb_url":"https://static.media.ccc.de/media/events/all_systems_go/2019/117-hd.jpg","poster_url":"https://static.media.ccc.de/media/events/all_systems_go/2019/117-hd_preview.jpg","timeline_url":"https://static.media.ccc.de/media/events/all_systems_go/2019/117-hd.timeline.jpg","thumbnails_url":"https://static.media.ccc.de/media/events/all_systems_go/2019/117-hd.thumbnails.vtt","frontend_link":"https://media.ccc.de/v/ASG2019-117-postgresql-at-low-level-stay-curious-","url":"https://api.media.ccc.de/public/events/8f67b425-117b-5575-839f-f6d9e3604f3a","conference_title":"All Systems Go! 2019","conference_url":"https://api.media.ccc.de/public/conferences/asg2019","related":[{"event_id":7864,"event_guid":"3d439f1d-e67a-5e92-96b6-3a9c5ad30965","weight":29},{"event_id":7865,"event_guid":"9dbd53a6-97d6-55b6-8ef0-e339aae4ff20","weight":16},{"event_id":7870,"event_guid":"878e4754-c346-5b93-96d2-1ca8bf5109c3","weight":28},{"event_id":7875,"event_guid":"21aca390-bc0c-5eef-a867-1b57a7ee36ab","weight":11},{"event_id":7878,"event_guid":"dcabb3af-fcac-5e83-a77d-5aa655cd95b3","weight":2},{"event_id":7882,"event_guid":"a738a107-7051-544d-98cf-b6c3adce4a3f","weight":2},{"event_id":7883,"event_guid":"40aa2960-6288-5a2f-bf6f-268746f0ecdf","weight":24},{"event_id":7892,"event_guid":"b231881d-afaf-56f5-a57a-eaaab6668d79","weight":2},{"event_id":7910,"event_guid":"b0b3fa50-d9db-511a-9fb1-9edb96bd3401","weight":27},{"event_id":7914,"event_guid":"53354cbe-c92f-5c48-82e3-194690b28f0c","weight":11},{"event_id":7917,"event_guid":"895baa61-c621-50c3-8b3b-1e69333f76a2","weight":11},{"event_id":7925,"event_guid":"fd85bb93-e67e-5ecc-ad41-8470024119fe","weight":11}],"recordings":[{"size":128,"length":2262,"mime_type":"video/mp4","language":"eng","filename":"asg2019-117-eng-PostgreSQL_at_low_level_stay_curious_hd.mp4","state":"new","folder":"h264-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2019-09-21T14:37:05.169+02:00","recording_url":"https://cdn.media.ccc.de/events/all_systems_go/2019/h264-hd/asg2019-117-eng-PostgreSQL_at_low_level_stay_curious_hd.mp4","url":"https://api.media.ccc.de/public/recordings/40312","event_url":"https://api.media.ccc.de/public/events/8f67b425-117b-5575-839f-f6d9e3604f3a","conference_url":"https://api.media.ccc.de/public/conferences/asg2019"},{"size":59,"length":2262,"mime_type":"video/mp4","language":"eng","filename":"asg2019-117-eng-PostgreSQL_at_low_level_stay_curious_sd.mp4","state":"new","folder":"h264-sd","high_quality":false,"width":720,"height":576,"updated_at":"2019-09-21T16:32:12.698+02:00","recording_url":"https://cdn.media.ccc.de/events/all_systems_go/2019/h264-sd/asg2019-117-eng-PostgreSQL_at_low_level_stay_curious_sd.mp4","url":"https://api.media.ccc.de/public/recordings/40363","event_url":"https://api.media.ccc.de/public/events/8f67b425-117b-5575-839f-f6d9e3604f3a","conference_url":"https://api.media.ccc.de/public/conferences/asg2019"},{"size":34,"length":2262,"mime_type":"audio/mpeg","language":"eng","filename":"asg2019-117-eng-PostgreSQL_at_low_level_stay_curious_mp3.mp3","state":"new","folder":"mp3","high_quality":false,"width":0,"height":0,"updated_at":"2019-09-21T16:32:38.192+02:00","recording_url":"https://cdn.media.ccc.de/events/all_systems_go/2019/mp3/asg2019-117-eng-PostgreSQL_at_low_level_stay_curious_mp3.mp3","url":"https://api.media.ccc.de/public/recordings/40364","event_url":"https://api.media.ccc.de/public/events/8f67b425-117b-5575-839f-f6d9e3604f3a","conference_url":"https://api.media.ccc.de/public/conferences/asg2019"},{"size":26,"length":2262,"mime_type":"audio/opus","language":"eng","filename":"asg2019-117-eng-PostgreSQL_at_low_level_stay_curious_opus.opus","state":"new","folder":"opus","high_quality":false,"width":0,"height":0,"updated_at":"2019-09-21T16:32:54.183+02:00","recording_url":"https://cdn.media.ccc.de/events/all_systems_go/2019/opus/asg2019-117-eng-PostgreSQL_at_low_level_stay_curious_opus.opus","url":"https://api.media.ccc.de/public/recordings/40365","event_url":"https://api.media.ccc.de/public/events/8f67b425-117b-5575-839f-f6d9e3604f3a","conference_url":"https://api.media.ccc.de/public/conferences/asg2019"},{"size":79,"length":2262,"mime_type":"video/webm","language":"eng","filename":"asg2019-117-eng-PostgreSQL_at_low_level_stay_curious_webm-sd.webm","state":"new","folder":"webm-sd","high_quality":false,"width":720,"height":576,"updated_at":"2019-09-21T16:33:40.840+02:00","recording_url":"https://cdn.media.ccc.de/events/all_systems_go/2019/webm-sd/asg2019-117-eng-PostgreSQL_at_low_level_stay_curious_webm-sd.webm","url":"https://api.media.ccc.de/public/recordings/40367","event_url":"https://api.media.ccc.de/public/events/8f67b425-117b-5575-839f-f6d9e3604f3a","conference_url":"https://api.media.ccc.de/public/conferences/asg2019"},{"size":190,"length":2262,"mime_type":"video/webm","language":"eng","filename":"asg2019-117-eng-PostgreSQL_at_low_level_stay_curious_webm-hd.webm","state":"new","folder":"webm-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2019-09-21T16:35:00.557+02:00","recording_url":"https://cdn.media.ccc.de/events/all_systems_go/2019/webm-hd/asg2019-117-eng-PostgreSQL_at_low_level_stay_curious_webm-hd.webm","url":"https://api.media.ccc.de/public/recordings/40371","event_url":"https://api.media.ccc.de/public/events/8f67b425-117b-5575-839f-f6d9e3604f3a","conference_url":"https://api.media.ccc.de/public/conferences/asg2019"}]}