October meeting recap

What a great meeting last night! Garlynn Woodsong gave us a tour of Urban Footprint, a scenario planning tool for development modeling. Fascinating! Did you know that “walkability” of a neighborhood can be determined by the number of intersections per square mile? And I learned a new term, “airshed” (like watershed, not bikeshed).

The fun really started at the end of his talk, when Garlynn mentioned “We’re having slow queries sometimes, what settings should we tune?” This sparked a lively discussion and resulted in probably our longest meeting ever. Matt Smiley gave us several tips on using top, iostat, and sar to troubleshoot.

Here’s the general procedure we came up with:
– Make sure you have monitoring configured correctly (including the pg activity log) and a decent baseline established. At a minimum: server CPU, memory, I/O, network, log slow queries.
– If you have other apps running on the db server, verify that it’s actually the db that’s causing the bottleneck.
– Back up your configs before you tinker with them; version control is advised.
– Start here: https://wiki.postgresql.org/wiki/Performance_Optimization with the first link: https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server

Thanks to Iovation for hosting us and providing pizza!

Next month, new member Eric Hanson’s going to talk about how he uses Postgres at Aquameta. See you then!

PDXPUG: October Meeting

When: 7-9pm Thu Oct 17, 2013
Where: Iovation
Who: Garlynn Woodsong
What: Urban Footprint

Garlynn Woodsong is a Project Manager in the regional and large-scale master planning team at Calthorpe Associates. He is a geographer and urban planner with more than 13 years of experience in transportation, land use, and regional and corridor planning and policy. His work and experience ranges from transit-oriented development, bicycle transportation planning, regional transportation policy and funding, to the use of GIS technology to support smart growth and regional planning efforts.

Garlynn’s going to expand on his lightning talk from earlier this year and give us a more in-depth look at UrbanFootprint, an open-source geospatial urban & regional scenario planning tool/ecosystem powered by PostgreSQL.

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!

Building security will close access to the floor at 7:30.

After-meeting beer location TBD. See you there!