PostgreSQL Meetup

Hi,

Let's kickoff the PostgreSQL Meetup Group in Berlin, get together at Zalando office in Berlin Mitte and share our PostgreSQL stories.

Hallo,

lasst uns die PostgreSQL Meetup Gruppe in Berlin gründen, kommt ins Zalando Büro in Berlin Mitte und teilt Eure Geschichten über PostgreSQL.

We'll have 2 talks this time (both of them in English):

• "Resolving addresses to geocoordinates, using OpenStreetMap or ArcGIS", by Andreas Scherbaum.

Companies collect huge amounts of data. In order to provide locationbased services, address data must be joined with geocoordinates and vice versa.

That's not an easy task: geocoordinates not always match an exactaddress, and addresses can have a broad variety of formats which makesthem unpleasant to parse and locate on a map.

This talk shows how addresses in your database can be resolved(geocoding) to coordinates, and geocoordinates can be transformed intoaddresses (reverse geocoding), all from inside a PostgreSQL database.Two different data sources are used, Open Street Map and Esri ArcGIS.

• "Autovacuum, explained for engineers", by Ilya Kosmodemiansky.

What is autovacuum, how it works and why it is so important? In this talk, I will cover PostgreSQL MVCC and Undo-management basics, problems and hazards of misconfigured autovacuum and a couple of strategies, how to make your PostgreSQL installation be happy about autovacuum. In addition I will show a couple of bloat-removing techniques and give some advices how to monitor autovacuum activity in your database.