{"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"],"view_count":224,"promoted":false,"date":"2021-04-10T11:00:00.000+02:00","release_date":"2021-04-14T00:00:00.000+02:00","updated_at":"2026-07-01T16:15:06.875+02:00","tags":["glt21","240","2021"],"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":[{"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","label":"deu 1080p","size":230,"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"},{"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","label":"deu","size":43,"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"},{"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","label":"deu 576p","size":86,"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"},{"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","label":"deu","size":25,"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"},{"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","label":"deu 576p","size":109,"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"},{"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","label":"deu 1080p","size":302,"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"}]}