TOAST, for breakfast and compression
13:45 - 14:30
dbi services Daniel Westermann
Das Beste seit geschnittenem Brot, oder „The Oversized Attribute Storage Technique“ ist ein Feature von PostgreSQL um das man sich normaleweise nicht kümmern muss. Es arbeitet im Hintergrund wie es soll, und man merkt gar nicht was da passiert. Trotz allem sollte man wissen was TOAST genau macht. Schlagwörter die hier wichtig sind: „Out-of-line-storage“ und Komprimierung. Beides kann gleichzeitig stattfinden, oder nur eines von beidem. Falls Daten im Spiel sind, die nicht in einen Block passen (normalerweise 8kB), dann ist dieser Vortrag genau das Richtige.
Daniel Westermann
dbi services
dbi services
Daniel Westermann is Principal Consultant and Technology Leader Open Infrastructure at dbi services. He has more than 15 years of experience in management, engineering and optimization of databases and infrastructures, especially on PostgreSQL. Since the beginning of his career, he has specialized in Oracle Technologies and is Oracle Certified Professional 12c and Oracle Certified Expert RAC/GridInfra. Over time, Daniel has become increasingly interested in open source technologies, becoming “Technology Leader Open Infrastructure” and PostgreSQL expert. Based on community or EnterpriseDB tools, he develops and installs complex high available solutions with PostgreSQL. He is a regular speaker at PostgreSQL conferences in Switzerland and Europe. Today Daniel is also supporting our customers on AWS services such as AWS RDS, database migrations into the cloud, EC2 and automated infrastructure management with AWS SSM (System Manager). He is a certified AWS Solutions Architect Professional. Prior to dbi services, Daniel was Management System Engineer at LC SYSTEMS-Engineering AG in Basel. Before that, he worked as Oracle Developper & Project Manager at Delta Energy Solutions AG in Basel (today Powel AG). Daniel holds a diploma in Business Informatics (DHBW, Germany). His branch-related experience mainly covers the pharma industry, the financial sector, energy, lottery and telecommunications