pg_reorg – A Tool You Can’t Live Without

Talk Type: 
45 Minute Talk
Track: 
Administration
Technical Level: 
Beginner
License: 
BSD

pg_reorg is a simple but very handy tool that allows to reorganize tables without downtime.
It helps to eliminate bloat, reduce IO, improve performance, delete large portion of a big table.
It may be especially handy in large sharded and replicated database environments.
Unfortunately, not too many people are familiar with the tool. This talk demonstrates how this tool may be used for making database administration a little easier.