Autovacuum’s like a Roomba, right? You just turn it on and it does all the work for you. Well, not quite – for one, your pets can’t ride around on it – and occasionally it may get stuck in a (figurative) corner. In this talk, we’ll discuss vacuum, analyze, and their daemonic counterparts: how to adjust them to perform appropriately*, and perhaps more importantly, what the heck are they actually doing?

This is a beginner-to-intermediate level talk, but you will learn something new about vacuuming, regardless.**
–

Gabrielle Roth is a consultant with EnterpriseDB. She specializes in network, database, and system monitoring, as well as abusing SQL.

–

After-meeting beer location: Huber’s, the oldest bar in Portland. See you there!

The focus of this meeting will be the local users of Cassandra. In an effort to 'bootstrap' the group there will be a presentation of some of the ways iovation uses Cassandra in our various tests. Please come with additional thoughts about ways you might want to see your user group shape itself.

Jay’s been experimenting with Pg’s full text search capabilities. At our next meeting, he’ll cover the following:
* Brief intro on why Google like search capabilities are fun.
* Introduce Postgresql full text abilities. Discuss at a high level why a full text index may be a bit heavier than a normal index.
* Look at possible solutions for use cases where the data you want to index is spread across multiple columns and multiple tables.

Jay Riddle is a database administrator at Viewpoint software.

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 6:45 and building security closes access to the floor at 7: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.

Come join an amazing group for happy hour at iovation! Be sure to find Amber Pham, Manager of Information Security at iovation. Read our newsletter for more fun facts about her; it's a great conversation starter!

PDX Women in Tech exists to celebrate professional women in the Portland-metro area who work with, manage, lead or have an interest in technology. Whether you are developing event-driven, non-blocking applications in node.js or setting technology strategy for a Fortune 500 company–or anything in between–come join us!

Please note the new earlier meeting time! We’ll try this over the winter.

Two topics this month: PgOpen attendees will discuss highlights of that conference, and Andrew will talk about some New Relic-y stuff.

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.

Amazon integrated Postgres into their general Relational Database Services (RDS) offerings July 1, 2014. RDS offers automatic failover, scalability, and easy configuration, plus Amazon handles all the patching and upgrades for you! Their SDK supports many languages and includes a robust CLI, if you want to automate management of your deployments. They also support several popular Postgres extensions.

Of course, since it’s a managed service, you can’t do everything you might expect or want to. In this talk, I’ll discuss the fun, the quirky, and the downright maddening features I’ve discovered working with production RDS deployments. Come find out what it’s like to use RDS Postgres day-to-day.

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.