PDXPUG - March meeting next week

When: 6-8pm Thursday Mar 19, 2015
Where: Iovation
Who: Ed Snajder
What: Creating an auto-partition strategy

Table partitioning is a great way to reduce cost and IO on very large data
sets, very often with analytics-type databases and systems that collect
historical data. While Postgres does offer table partitioning and the
advantages that go with it, the care and feeding of partitioned systems can
be tedious and error-prone, and Postgres does not offer a lot of built-in
tools to help to reduce administrative overhead.

Ed will share his approach to tackling this, with a set of functions that
will take an existing table, create partitions on it, and ultimately
migrate the data. He'll also, time permitting, compare to the more mature
pg_partman.

--

Our meeting will be held at Iovation, on the 32nd floor of the US Bancorp
Tower at 111 SW 5th (5th & Oak). It's right on the Green & Yellow Max
lines. Underground bike parking is available in the parking garage;
outdoors all around the block in the usual spots. No bikes in the office,
sorry!

Elevators open at 5:45 and building security closes access to the floor at
6:30.

The building is on the Green & Yellow Max lines. Underground bike parking
is available in the parking garage; outdoors all around the block in the
usual spots.

See you there!