PG Performance

Partitioning & Creating Hardware Tablespaces for Performance

In this presentation we will go over using how to improve your speed performance by using partitioning and table spaces.

Index Bloat

Causes of Index Bloat:

  • Large churning of data on a table.
  • Every time you vacuum or vacuum analyze a table, this will cause index bloat.
  • Vacuum does not vacuum the indexes.

In this presentation we will go over how to find index bloat, monitor index bloat, and fix index bloat.

Bulk Commands

We will go over how to do everything in Bulk. This way of doing things will help you speed up your applications.

I will also show how to use these principals to refactor several function which run in 3 1/2 hour to now run in less than 6 1/2 seconds.