Even though PG Con West will be going on October 10-12 in sunny (we hope) Portland, we will still have our monthly meeting on October 16, 2008. This month, Selena Deckelmann will provide a tutorial on setting up Point-in-time recovery (PITR) for your PostgreSQL installation. This will be hands on, with the ever-dangerous LIVE DEMO.
We will be meeting at FreeGeek – 1731 SE 10th Avenue, Portland, OR.
In November, our own Randal Schwartz of Stonehenge Consulting (http://www.stonehenge.com/) will be giving a talk on Smalltalk and Postgres integration.
Looking forward to seeing everyone there….and of course, drinks at the Lucky Lab (http://www.luckylab.com/ ) at 915 SE Hawthorne Blvd. afterwards.
Topic: Visual Planner
Presenter: Tom Raney, PSU
Where: FreeGeek, 1731 SE 10th Avenue, Portland, OR
When: 7pm, September 18, 2008
Tom Raney will be presenting the Visual Planner, a GUI tool written in Java that enables the user to peek inside the PostgreSQL planner’s decision making process. The tool shows all plans that were evaluated including the plan that was picked for execution. Tom worked on this during Google Summer of Code, and credits Dr. Len Shapiro, a professor at Portland State University and PDXPUG regular, as a great help.
Tom showed off his tool during OSCON and has gotten some feedback from community members on it. He’s working up a test example that should appeal to DBAs, and I’ll link directly to the source code once he’s got it ready.
This work also involves a patch to PostgreSQL, which should be available soon!
After the meeting, retire to the Lucky Lab for refreshments!