Posts tagged ‘pgopen’

31 August, 2016

My Picks for PgOpen 2016

by gorthx

We’re back in Dallas for our 6th year of PostgresOpen!  This year, we’re out at the Westin Galleria, which I’m told has an ice rink. (Is it too late for someone bring the Slonik costume?)

In addition to choosing the talks for the program, part of my conference committee duties involve being a room host. I won’t get to see everything I want, but here’s five that are at the top of my “wish list”:

  • Denish Patel’s Advanced Postgres monitoring – always looking for ways to do this better
  • *Of course* I will be in Grant McAlister’s RDS talk
  • Shaun Thomas clearly and simply explains even advanced topics, and I usually come out of the room thinking “BOY am I glad I don’t have to deal with THAT situation”. This year is Elephant Herd as a Service
  • Sounds like there are some “interesting” stories behind Ilya Kosmodemiansky’s PostgreSQL Worst Practices
  • And we are really excited to have Alexander Korotkov and Oleg Bartunov join our conference to talk about RUM indexes!

A couple of other sessions I recommend:

Check out Dimitri Fontaine’s You’d Better Have Tested Backups ; it’s pretty hair-raising.

Want to contribute back to Postgres, but don’t know where to start? Review some patches! David Steele will give you some pointers.

We will be having Lightning Talks, as usual. If you want to get the jump on everyone else, you can sign up here.

What’s new this year: instead of an auction, we’re having a golf tournament.  I’ve never golfed before and am looking forward to giving it a try. Come join us, it’ll be a hoot. (There is a dress code so pack accordingly if you think you might want to play.)

See you in Dallas in a few weeks! Stop by the reg desk and say hello.

28 September, 2015

PgOpen recap

by gorthx

We’ve wrapped up another PostgresOpen! The official numbers aren’t in yet, but we were up a significant percentage from last year. We had so many last-minute registrants and walk-ups that we ran out of extra badges.

Even better, I got to attend most of the talks on my list.

I can’t pick a favorite, but judging by the amount of notes I took, I learned the most in Joe Celko’s talk on measurement scales. The concepts and nomenclature were vaguely familiar from my long-ago education in the sciences, and it was interesting to tie them in with what I’m doing now.

Grant gave an excellent introduction to RDS Pg. I even learned some things. If you’re new to RDS Postgres, you should take this tutorial next time it’s offered. I continue to be impressed with the RDS team members; not only are they a whip-smart group, they’re also very personable and kind.

I learned about \ef (allows you to edit functions in place) in Keith Fiske’s Don’t Forget the Elephant, and was also reminded of how far Postgres has come, even just since 9.0. So many useful features!

Stella’s SQL Guru talk gave me some good pointers on window functions.

Slides for most of the talks are available on the wiki, and videos are on the way.

Between the social events and prepping for the Tour des Fleurs, I did not have time to see much of Dallas. I’ll likely run the TDF again next year, if the conf coincides with it. LMK if you’d like to join. The course is mostly flat; there’s one small hill.

Great to see everyone and hope to see you again next year!

30 August, 2015

My “Must-see” List for PgOpen

by gorthx

PostgresOpen is coming up in just a few weeks! (Disclosure: I am on the conference committee.) We are still working out the room assignments; your conference badge/printed program will have the right info.

The committee is very excited to have snagged Lacey Williams Henschel to give our keynote, on Open Source & Higher Ed. I’m looking forward to meeting her! (The real reason I’m at the reg desk is to try to meet everyone ;) )

As in previous years, four tutorials are scheduled for the day before the conference proper. As anyone who’s talked to me in the past year could guess, I’m most excited about Grant McAlister’s RDS tutorial. There’s always more to learn about this quickly maturing platform.

My picks for the rest of the conference are as follows:
Thursday sessions:
– Kevin Kempter’s Monitoring Postgres

– Joe Conway’s R talk

– Sarah Conway’s security talk was SRO last year; this year she’s back to focus on security in RDS. (In the same time slot, Jim Mlodgenski’s FDW talk is a good intro to that subject.)

– I’ve been using SQL for a while now :koff: but I’m still not that great at some things like window functions, so I’ll be in Stella Nisenbaum’s SQL Guru talk.

– Then I’ll finish out my day with David Steele’s Audit Logging.

Friday sessions:
– I’ve been enjoying the “History of Postgres”-type talks we’ve had at a few confs lately, and am looking forward to Keith Fiske’s version, Don’t Forget the Elephant.

– Shaun Thomas Highly Available Postgres.

– Of course I’ll be in Peter Don’t-even-try-to-pronounce-it Geoghegan’s UPSERT use cases.

– I’ve caught Magnus Hagander’s Tardis talk at NYC earlier this year. If you haven’t had the chance, you should check it out!

– And last, Phil Vacca’s Text Search.

We will be having a lightning talk session, as in previous years. Signups will open soon; watch the conference twitter stream for announcements.

It’s not too late to register, but our hotel room rate and reservation block expires on Sept 2, so act fast! If you’re a member of a PUG, ask your group leader for the conference discount code. (If you’re a PUG leader and haven’t received the code, please email the conference committee.

18 August, 2014

My PostgresOpen schedule

by gorthx

We had so many good submissions for Postgres Open this year, we had to make some very difficult choices. While I haven’t quite achieved Dan Langille’s (of PgCon fame) level of conference-running zen and rarely get to all the talks I’d like to see, here are my picks:

The PostGIS tutorials. I am really excited about this tutorial, and that Regina Obe and Leo Hsu will be at our conference!

Bruce Momjian and Vibhor Kumar’s NoSQL on ACID (plus pizza and root beer!) Most everyone knows who Bruce is, but you may not know Vibhor – I got to work with him at EDB, and he’s very kind and always had answers to my most obscure questions. This tutorial is free, but you have to register in advance. If you’re coming to the conf early, this is a great thing to do on your first evening.

Denish Patel gives great presentations, and I’m looking forward to learning about Pg on RDS from him.

Streaming replication was first introduced in 9.0. Simon Rigg’s Pg Replication Overview will bring you up to speed on the new developments since then.

You can read the 9.4 release notes or just go to Magnus Hagander’s talk.

I’m really interested in the tools that Gleb Arshinov used for his customer retention analysis use case.

Jonathan Katz’s data types tour has had rave reviews, and I’m glad he’s giving it again here.

Jeff Amiel’s Monolithic Query Syndrome talk looks educational and entertaining.

I can’t decide between Sehrope Sarkuni’s Audit logging talk and Gary Seiling’s discussion about immutable data. (Note: if you are new to Postgres and configuring its security features, I recommend pairing one of these with Sarah Conway’s introductory talk on Thursday.)

Full text search is a hot topic right now.

I will almost always choose a monitoring talk over any other topics, so Shaun Thomas’s collectd and graphite talk is on my list.

What’s the state of Row level Security in Postgres? Go to this talk by Stephen Frost and find out.

John Melesky is a fellow PDXPUGer and always bring interesting problems to the table. This time he’s talking about partitions.

It’s not too late to join us in Chicago!

27 September, 2013

PgOpen recap

by gorthx

Previous years:

PgOpen returned to Chicago for its 3rd year, and just keeps getting better and better. We moved the venue to Hotel Sax, a funky place with friendly staff and a pretty amazing catering service. (I’m just here for the food.)

My talk picks:
Schema migrations with Alembic (Selena Deckelmann) – inspired me to try out this tool.
Using Postgres FDW (John Melesky) – I love the “here is what I did and I don’t really recommend it” talks.
Inside Pg Shared Memory (Bruce Momjian) – Bruce’s talks are always thorough overviews and this one did not dissapoint.
Replication Refresh (Simon Riggs) – basic discussion of the current state of Pg replication
Secure your Webapp Passwords in Pg (Magnus Hagander) – sensible information delivered with humor.

Links to slides for these and most of the remaining talks are on the wiki. If you presented and haven’t uploaded your slides yet, this is your cue. :)

Of course, the best part of the conference is meeting new people, and people new to Postgres (hi, Catherine!).

As we are a community-supported event, we like to contribute back to the local community as well. Big thanks to Steven Frost for running the auction again! This year, in addition to funds generated from the auction, other members of the Pg community chose to donate cash on the spot. The conference committee matched some contributions, and we raised over $3500 for Chicago Hopes! Thank you.

I’m really excited to be on the committee again next year! Planning starts soon for PgOpen 2014, so if you haven’t already, please fill out the survey.

24 September, 2012

PgOpen Recap

by gorthx

Another year, another excellent conference. This go-round was even better than last year’s.

There were lots of new folks at the conference this year; welcome to the community!

I made it to most of the talks I’d planned to, and of course came away with lot of ideas for things I want to try at home, such as the examples from Jon Erdman’s lightning talk about pgdump -Fc.

My fave was Dimitri Fontaine’s Large Scale MySQL Migration, because I like the ‘war stories’. (I would not have been surprised if he’d said “…and then some alligators tried to eat us!”) Denish Patel’s lightning talk was hilarious, and I am looking forward to messing around with the pg_stat_plans extension Greg Smith & Peter Geoghegen discussed during Query Logging and Workload Analysis.

I was half-drafted/half-volunteered to be on the conference committee for next year. We’ll strive to uphold the fine level of conference to which you’ve become accustomed. (If you attended this year’s conference, don’t forget to fill out the survey!)

P.S. Thanks to Greg Smith for leveraging his frequent-flyer powers for good, and getting me on a different flight when I missed mine. This really shows the “community” part of the Postgres Community.

17 August, 2012

My Picks for Postgres Open 2012

by gorthx

The schedule for Postgres Open is out!

Here are the talks I’m planning on attending:
Range Types in PostgreSQL 9.2 (Jonathan S Katz)

Large Scale MySQL Migration to PostgreSQL (Dimitri Fontaine) because I love case studies

12 Calm Years of PostgreSQL in Critical Messaging (John Scott) another case study

This is PostGIS (Paul Ramsey) <– 'nuff said

If I wasn't giving a talk at the same time, I’d be going to High Availability with PostgreSQL and Pacemaker (Sean M. Thomas)

Of course, I will be attending the Lightning Talks!

Super Jumbo Deluxe (Josh Berkus)

For the next few sessions, I’ll require a coin toss to decide between:
Deploying Maximum HA (Denish Patel)
Scaling Postgres with some help from Redis (Josiah Carlson)

Query Logging and Workload Analysis (Greg Smith)
DVDStore Benchmark (Jignesh Shah)

The penultimate session is going to be tough to choose. Today I am leaning toward A Batch of Commit Batching (Paul Geoghegan)

To wrap it up, I want to hear about PG Extractor – A Smarter pg_dump (Keith Fiske)

I’m looking forward to the hallway track & meeting old & new friends. This was a really good conference last year & it’s not too late to register. Hope to see you there!

10 August, 2012

Speaking at Postgres Open

by gorthx

I’m speaking at Postgres Open again this year! I’ll be giving an updated version of my Intro to Logging talk.

Come by early registration (aka “pub registration”) Sunday evening and say hello.