# PostgreSQL Conference Europe, 2018

DevFeed: [PostgreSQL Conference Europe, 2018](<https://devfeed.tech/articles/postgresql-conference-europe-2018-34655.md>)

Original publisher: [Read original article](<https://tapoueh.org/conf/postgresql-conference-europe-2018/>)

Published: 2018-10-23T22:00:00Z

Content type: article

Language: en

Sources: [Dimitri Fontaine](<https://devfeed.tech/sources/dimitri-fontaine.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Database](<https://devfeed.tech/topics/database.md>), [Structured-data](<https://devfeed.tech/topics/structured-data.md>)

Tags: [conference](<https://devfeed.tech/tags/conference.md>), [design](<https://devfeed.tech/tags/design.md>), [examples](<https://devfeed.tech/tags/examples.md>), [network](<https://devfeed.tech/tags/network.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [schema](<https://devfeed.tech/tags/schema.md>), [techniques](<https://devfeed.tech/tags/techniques.md>), [types](<https://devfeed.tech/tags/types.md>)

## AI overview

A PGConf.EU talk about modeling PostgreSQL database schemas, including schema design trade-offs, normalization examples, anti-patterns, PostgreSQL solutions, and denormalization using advanced data types.

## Source excerpt

As a developer using PostgreSQL one of the most important tasks you have to deal with is modeling the database schema for your application. In order to achieve a solid design, it's important to understand how the schema is then going to be used as well as the trade-offs it involves. As Fred Brooks said: "Show me your flowcharts and conceal your tables, and I shall continue to be mystified. Show me your tables, and I won't usually need your flowcharts; they'll be obvious." In this talk we're going to see practical normalisation examples and their benefits, and also review some anti-patterns and their typical PostgreSQL solutions, including Denormalization techniques thanks to advanced Data Types.