About
Andreas Scherbaum is working with PostgreSQL since 1997. He is involved in several PostgreSQL related community projects, member of the Board of Directors of the European PostgreSQL User Group and also wrote a PostgreSQL book (in German). Since 2011 he is working for EMC/Greenplum/Pivotal and tackles very big databases.
Andreas Scherbaum has presented the following presentations
Petabyte Scale Data Warehousing with Open Source Greenplum Database
at
Postgres Conference
presented by Marshall Presser, Andreas Scherbaum, and Craig Sylvester
It's more than just storing and retrieving data. Equally important are loading high volume data in parallel and running analytics in the database. This hands-on session will lead you through the entire process of creating, loading, and analyzing data in the Greenplum MPP database. It's PostgreSQL, but bigger and DWH-focused.
At the end of this workshop, attendees will learn modern DWH techni...
more Mon 18 2019 Greenplum Summit
Tour de Data Types: VARCHAR2 or CHAR(255)?
at
PGConf US 2017 [PgConf.US]
presented by Andreas Scherbaum
video
Ever wondered what might be the best data type for a certain use case? Is it better to use INTEGER or BIGINT, and should you use TIMESTAMP or is it better to use TIMESTAMPTZ? When is the last time you migrated a legacy database and wondered what to use as replacement for VARCHAR2 or CHAR(255)? How to store IP addresses or geographical data, does that fit into VARCHAR or is there something more ...
more Development
How we made Greenplum Open Source
at
PGConf US 2016 [PgConf.US]
presented by Andreas Scherbaum
Greenplum is a PostgreSQL fork, optimized for Analytics and Data Warehouse use cases. Pivotal announced in early 2015 that a number of products will go Open Source, one of them is Greenplum Database. This talk provides an overview over the history of Greenplum, the entire process of bringing the product into Open Source, all the stumbling blocks we ran into, and explains how contributors can pa...
more Internals
Enrich your data with geocoordinates from OpenStreetMap or ArcGIS
at
PGConf US 2015 [PgConf.US]
presented by Andreas Scherbaum
BOfH subtitle: Mark your customers profiles with ICBM coordinates Companies collect huge amounts of data. In order to provide location based services, address data must be coupled with geocoordinates and location based events must be coupled with nearest address information. That's not an easy task: geocoordinates not always match an exact address, and addresses can have a broad variety of form...
more GIS
Petabyte Scale Data Warehousing with Open Source Greenplum Database
at
PostgresConf US 2018
presented by Marshall Presser and Andreas Scherbaum
It's more than just storing and retrieving data. Equally important are loading high volume data in parallel and running analytics in the database. This hands-on session will lead you through the entire process of creating, loading, and analyzing data in the Greenplum MPP database. It's PostgreSQL, but bigger and DWH-focused.
At the end of this workshop, attendees will learn modern DWH tec...
more Greenplum Summit
Tour de Data Types: VARCHAR2 or CHAR(255)?
at
PostgresConf US 2018
-
presented by Andreas Scherbaum
Ever wondered what might be the best data type for a certain use case? Is it better to use INTEGER or BIGINT, and should you use TIMESTAMP or is it better to use TIMESTAMPTZ? When is the last time you migrated a legacy database and wondered what to use as replacement for VARCHAR2 or CHAR(255)? How to store IP addresses or geographical data, does that fit into VARCHAR or is there something more ...
more Thu 19 2018 Development