{"guid":"b2dd08d2-35dd-52d5-bc66-4ddf2ed0ef79","title":"PostgreSQL: Typische Performance Optimierungen","subtitle":null,"slug":"glt21-240-postgresql-typische-performance-optimierungen","link":"https://pretalx.linuxtage.at//glt21/talk/FSLGDM/","description":"PostgreSQL ist mittlerweile im Mainstream angekommen. Bei einem größeren Deployment ist es aber wichtig, entsprechend auf die Performance zu achten. Dieser Vortrag fasst die wichtigsten Schritte zusammen.\n\nPerformance ist ein wesentliches Thema beim professionellen Betrieb einer Datenbank. Das gilt natürlich auf für PostgreSQL. Im Zuge des Vortrags wollen wir auf die wesentlichen Performance Themen eingehen und sehen, wie man diese Dinge in der Praxis anwenden kann.","original_language":"deu","persons":["Hans-Jürgen Schönig"],"tags":["glt21","240","2021"],"view_count":218,"promoted":false,"date":"2021-04-10T11:00:00.000+02:00","release_date":"2021-04-14T00:00:00.000+02:00","updated_at":"2026-02-12T16:30:06.813+01:00","length":2790,"duration":2790,"thumb_url":"https://static.media.ccc.de/media/events/glt/2021/240-b2dd08d2-35dd-52d5-bc66-4ddf2ed0ef79.jpg","poster_url":"https://static.media.ccc.de/media/events/glt/2021/240-b2dd08d2-35dd-52d5-bc66-4ddf2ed0ef79_preview.jpg","timeline_url":"https://static.media.ccc.de/media/events/glt/2021/240-b2dd08d2-35dd-52d5-bc66-4ddf2ed0ef79.timeline.jpg","thumbnails_url":"https://static.media.ccc.de/media/events/glt/2021/240-b2dd08d2-35dd-52d5-bc66-4ddf2ed0ef79.thumbnails.vtt","frontend_link":"https://media.ccc.de/v/glt21-240-postgresql-typische-performance-optimierungen","url":"https://api.media.ccc.de/public/events/b2dd08d2-35dd-52d5-bc66-4ddf2ed0ef79","conference_title":"Grazer Linuxtage 2021","conference_url":"https://api.media.ccc.de/public/conferences/glt21","related":[],"recordings":[{"size":301,"length":2790,"mime_type":"video/webm","language":"deu","filename":"glt21-240-deu-PostgreSQL_Typische_Performance_Optimierungen_webm-hd.webm","state":"new","folder":"webm-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2021-04-14T10:20:45.606+02:00","recording_url":"https://cdn.media.ccc.de/events/glt21/webm-hd/glt21-240-deu-PostgreSQL_Typische_Performance_Optimierungen_webm-hd.webm","url":"https://api.media.ccc.de/public/recordings/52926","event_url":"https://api.media.ccc.de/public/events/b2dd08d2-35dd-52d5-bc66-4ddf2ed0ef79","conference_url":"https://api.media.ccc.de/public/conferences/glt21"},{"size":108,"length":2790,"mime_type":"video/webm","language":"deu","filename":"glt21-240-deu-PostgreSQL_Typische_Performance_Optimierungen_webm-sd.webm","state":"new","folder":"webm-sd","high_quality":false,"width":720,"height":576,"updated_at":"2021-04-14T09:52:03.315+02:00","recording_url":"https://cdn.media.ccc.de/events/glt21/webm-sd/glt21-240-deu-PostgreSQL_Typische_Performance_Optimierungen_webm-sd.webm","url":"https://api.media.ccc.de/public/recordings/52907","event_url":"https://api.media.ccc.de/public/events/b2dd08d2-35dd-52d5-bc66-4ddf2ed0ef79","conference_url":"https://api.media.ccc.de/public/conferences/glt21"},{"size":24,"length":2790,"mime_type":"audio/opus","language":"deu","filename":"glt21-240-deu-PostgreSQL_Typische_Performance_Optimierungen_opus.opus","state":"new","folder":"opus","high_quality":false,"width":0,"height":0,"updated_at":"2021-04-14T09:51:22.575+02:00","recording_url":"https://cdn.media.ccc.de/events/glt21/opus/glt21-240-deu-PostgreSQL_Typische_Performance_Optimierungen_opus.opus","url":"https://api.media.ccc.de/public/recordings/52905","event_url":"https://api.media.ccc.de/public/events/b2dd08d2-35dd-52d5-bc66-4ddf2ed0ef79","conference_url":"https://api.media.ccc.de/public/conferences/glt21"},{"size":85,"length":2790,"mime_type":"video/mp4","language":"deu","filename":"glt21-240-deu-PostgreSQL_Typische_Performance_Optimierungen_sd.mp4","state":"new","folder":"h264-sd","high_quality":false,"width":720,"height":576,"updated_at":"2021-04-14T09:46:06.333+02:00","recording_url":"https://cdn.media.ccc.de/events/glt21/h264-sd/glt21-240-deu-PostgreSQL_Typische_Performance_Optimierungen_sd.mp4","url":"https://api.media.ccc.de/public/recordings/52902","event_url":"https://api.media.ccc.de/public/events/b2dd08d2-35dd-52d5-bc66-4ddf2ed0ef79","conference_url":"https://api.media.ccc.de/public/conferences/glt21"},{"size":42,"length":2790,"mime_type":"audio/mpeg","language":"deu","filename":"glt21-240-deu-PostgreSQL_Typische_Performance_Optimierungen_mp3.mp3","state":"new","folder":"mp3","high_quality":false,"width":0,"height":0,"updated_at":"2021-04-14T09:40:15.433+02:00","recording_url":"https://cdn.media.ccc.de/events/glt21/mp3/glt21-240-deu-PostgreSQL_Typische_Performance_Optimierungen_mp3.mp3","url":"https://api.media.ccc.de/public/recordings/52898","event_url":"https://api.media.ccc.de/public/events/b2dd08d2-35dd-52d5-bc66-4ddf2ed0ef79","conference_url":"https://api.media.ccc.de/public/conferences/glt21"},{"size":229,"length":2790,"mime_type":"video/mp4","language":"deu","filename":"glt21-240-deu-PostgreSQL_Typische_Performance_Optimierungen_hd.mp4","state":"new","folder":"h264-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2021-04-14T09:31:45.775+02:00","recording_url":"https://cdn.media.ccc.de/events/glt21/h264-hd/glt21-240-deu-PostgreSQL_Typische_Performance_Optimierungen_hd.mp4","url":"https://api.media.ccc.de/public/recordings/52894","event_url":"https://api.media.ccc.de/public/events/b2dd08d2-35dd-52d5-bc66-4ddf2ed0ef79","conference_url":"https://api.media.ccc.de/public/conferences/glt21"}]}