Piet de Visser

Partitioning - Positives and Pitfalls.

Piet de Visser
PDVBV

This presentation can help you to avoid problems when using Partitioning. The oneliner is : Simple Works Best.

The experience (and possibly some demos) is mainly Oracle based, but I am investigating the possibilities of PostgreSQL as well. PostgreSQL is only Starting to get the benefits, but there is Real Potential here.

Partitioning will notably help you to store and “manage” large tables of facts or items. Expect Partitioning to be or to become an effective tool to store very large, and often volatile sets of data in a “relational” database. Once you know the possibilities, and the (dis)advantages, and if you know the use-case, you can help deliver a succesful implementation of partitioning.


Informacije o predavanju

Jezik / Language: ENG


About author

Piet is an experienced Database Consultant and DBA. He is in IT since 1987, and specializes in Oracle-, Postgres- and Databases-related technology since 1994. He combines conceptual knowledge and technical know-how with extensive experience in global and complex organizations.

He also invests a lot of effort in maintaining a network of Like-Minded database-specialists worldwide and is a regular speaker at international user group events and symposia.

Piet likes to Travel, speaks various languages more or less fluently, and is alway insterested in learning how to say "Hello" and "Thank You" in a few more languages (provided he can learn it in-situ).

  • # Database
  • # Partitioning