Loading
  • PostgreSQL 13 Beta Preview with Christophe Pettus—Joint Event with Portland PUG!

    SFPUG is going virtual—and we're doing a joint Meetup with our friends at the Portland PUG! Join us online on June 18, 2020 as Christophe Pettus presents a preview of the PostgreSQL 13 beta. This exciting new release has many new features, covering a wide range of functionality: Indexing, query functionality and performance, vacuuming, monitoring and status reporting, partitioning, and a host of others. We'll talk about the highlights of what to expect in version 13. Christophe Pettus is the CEO and lead consultant of PostgreSQL Experts, Inc., a decade-old independent PostgreSQL consultancy. Schedule: 7:00 PM Announcements, speaker introduction, presentation, Q&A. 8:15 PM Closing announcements, wrap up. 8:30 PM Event ends. Link for the GoToMeeting room will be sent the day of the event.

    14
  • JSONB Tricks: Operators, Indexes, And When To (NOT) Use It

    SFPUG is going virtual! Join us online on May 19, 2020 as Colton Shepard presents, "JSONB Tricks: Operators, Indexes, And When To (NOT) Use It". When do you use jsonb, and when don’t you? How do you make it fast? What operators are available, and what can they do? How will this change? These are all very good questions, but jsonb support in Postgres moves so fast that it’s hard to keep up. In this talk, you will get details on these topics, complete with practical examples and real-world stories: *When to use jsonb, what it’s good for, and when to not use it *Operators and how to use them effectively *Indexing, operator support for indexes, and the tradeoffs involved *Postgres 12 improvements and new features I was a Solutions Engineer at Citus Data, and continue to perform the same role at Microsoft now that we've been acquired. I have specialized in data, application, and stored procedure migrations, and tend to get weird and interesting problems to solve. Schedule: 7:00 PM Announcements, speaker introduction, presentation, Q&A. 8:15 PM Closing announcements, wrap up. 8:30 PM Event ends. Link and password for the GoToMeeting room will be sent the day of the event.

    2
  • SF PUG for November 2019

    Neustar, Inc.

    Thank you to Neustar for hosting! Join us on November 19, 2019 for two presentations! 1. "PostgreSQL for SQL Server DBAs" with Chandra Sekhar Pathivada. The demand for polyglot DBAs, proficient with more than one database, is a common feature of current job descriptions. We'll discuss how knowledge of SQL Server helps to learn PostgreSQL. Chandra is a PMP and AWS Certified Solutions Architect, currently working with Datavail Corporation as a Senior Cloud Database Architect. Chandra has around 18 years of experience on a broad range of databases, which include PostgreSQL, SQL Server,MySQL, and Redshift. 2. "Postgres 12—Now That It's Here, What Do I Do With It?" with Christophe Pettus. PostgreSQL 12 was released on October 3. While the release report tells us what changes to expect, how do you actually incorporate them into your work? Christophe has been using Postgres since the 7.2 days. He consults on all sorts of database and application things as CEO of PostgreSQL Experts, Inc. Schedule: 6:30 PM Doors open for socializing and food. 7:00 PM Announcements, speaker introduction, presentations, Q&A. 8:15 PM Closing announcements, wrap up. 8:30 PM Event ends. RSVP NOTE: If your Meetup profile doesn't show your full name, please contact the organizers via Direct Message to give us your first and last name. We have to provide a list to the building for access. If you do not provide your full name, you will not be able to attend. Even if you have provided it before, if your full name does not show on your current profile, you need to send it to us. We have over 1,600 members, so you need to let us know which one you are. Thanks!

  • "Migrating Data Quickly and Safely" with Aaron Webber

    Thank you to Heap for hosting! Join us on October 22, 2019 as Aaron Webber presents, "Migrating Data Quickly and Safely". Data and schema migrations have always been an operational challenge for administrators of relational databases, and integrating migrations into a modern CD pipeline is even more painful. We want developers to be able to quickly write and deploy schema changes, but we don't want to take down the site! In addition, a schema change that will take hours or require scheduled downtime in production should be applied transparently in development and testing environments. At Nextdoor, we solved this in a way that allows developers to move fast while keeping customer data safe. Aaron Webber is a software engineer on the Infrastructure team at Nextdoor, where his job is building tools that help the engineering team move fast and scaling the infrastructure that keeps the site up. He gets very excited about observability, getting data in the hands of engineers, and long and complicated board games. Schedule: 6:30 PM Doors open for socializing and food. 7:00 PM Announcements, speaker introduction, presentation, Q&A. 8:15 PM Closing announcements, wrap up. 8:30 PM Event ends. RSVP NOTE: If your Meetup profile doesn't show your full name, please contact the organizers via Direct Message to give us your first and last name. We have to provide a list to the building for access. If you do not provide your full name, you will not be able to attend. Even if you have provided it before, if your full name does not show on your current profile, you need to send it to us. We have almost 1,600 members, so you need to let us know which one you are. Thanks!

  • "Why Postgres? Why This Database? Why Now?" with Claire Giordano

    Thank you to NextDoor for letting us meet at your office! PostgreSQL Experts will be sponsoring the food for tonight. Join us on July 23, 2019 as Claire Giordano presents, "Why Postgres? Why This Database? Why Now?". I spent the early part of my career working on developer tools, operating systems, high-speed file systems, and scale-out storage. Not databases. Frankly, I always thought that databases were a bit boring. So almost 2 years in to my new job at a Postgres company, I continue to be amazed at the enthusiasm of the PostgreSQL developer community and users. I mean, people’s eyes light up when you ask them why they love Postgres. Sure, a lot of us get animated when talking about our newest gadget, the wins and losses of women’s world cup soccer, or mint chip gelato from La Strega Nocciola—but most platform software simply doesn’t trigger this kind of passion. So why does Postgres? Why is this open source database having such a “moment”? Well, I’ve been trying to understand, looking at this “Postgres moment” from a few different angles. In this talk I’ll share what I’ve observed to be the top 10 business, technology, and community reasons so many of you have so much affection for PostgreSQL. Claire Giordano is a Principal PM Manager on the Citus team at Microsoft. Prior to the Microsoft acquisition of Citus Data in Jan 2019, Claire was VP of Marketing at Citus Data, where she led the team to raise awareness about the worry-free Postgres database that is Citus. Claire has served in leadership roles in engineering, product management, and marketing at Citus Data, Sun Microsystems, Quantum, and A9, an Amazon company. At Sun, Claire managed the engineering team that created Zones, and led the effort to open source Solaris. Claire’s career in tech started in Providence, where she earned an Sc.B. in Applied Mathematics & Computer Science from Brown University. Schedule: 6:30 PM Doors open for socializing and food. 7:00 PM Announcements, speaker introduction, presentation, Q&A. 8:15 PM Closing announcements, wrap up. 8:30 PM Event ends. RSVP NOTE: If your Meetup profile doesn't show your full name, please contact the organizers via Direct Message to give us your first and last name. We have to provide a list to the building for access. If you do not provide your full name, you will not be able to attend. Even if you have provided it before, if your full name does not show on your current profile, you need to send it to us. We have almost 1,600 members, so you need to let us know which one you are. Thanks!

  • "Look It Up: PostgreSQL Indexes" with Christophe Pettus

    Salesforce Tower

    Thank you to Salesforce for hosting! Join us on June 18, 2019 as Christophe Pettus presents, "Look It Up: PostgreSQL Indexes". PostgreSQL has a huge range of possible index types above the traditional B-Tree: GiST, GIN, SP-GiST, BRIN, Hash… and some that aren't even part of the core. When do you use them? What are they good for? How well do they perform? This talk goes over the collection of exotic animals that is PostgreSQL's indexes, along with how to use them properly. Christophe has been using Postgres since the 7.2 days. He consults on all sorts of database and application things through PostgreSQL Experts, Inc. Schedule: 6:30 PM Doors open for socializing and food. 7:00 PM Announcements, speaker introduction, presentation, Q&A. 8:15 PM Closing announcements, wrap up. 8:30 PM Event ends. RSVP NOTE: If your Meetup profile doesn't show your full name, please contact the organizers via Direct Message to give us your first and last name. We have to provide a list to the building for access. If you do not provide your full name, you will not be able to attend. Even if you have provided it before, if your full name does not show on your current profile, you need to send it to us. We have almost 1,600 members, so you need to let us know which one you are. Thanks!

  • "Enabling Encryption at Rest on RDS" with Christos Christoudias

    Thank you to Instacart for hosting! Join us on April 16, 2019 as Christos Christoudias presents, "Enabling Encryption at Rest on RDS". Enabling Encryption at Rest (EAR) is a relatively simple process on AWS' RDS for a new database. But getting there with an existing database while avoiding downtime isn't as easy. Christos will talk through Instacart's approach towards getting there, including benchmarking of pg_logical vs. PG 10.+ built-in logical replication. Christos is a Senior Software Engineer at Instacart and is part of the company's Postgres working group. Schedule: 6:30 PM Doors open for socializing and food. 7:00 PM Announcements, speaker introduction, presentation, Q&A. 8:15 PM Closing announcements, wrap up. 8:30 PM Event ends. RSVP NOTE: If your Meetup profile doesn't show your full name, please contact the organizers via Direct Message to give us your first and last name. We have to provide a list to the building for access. If you do not provide your full name, you will not be able to attend. Even if you have provided it before, if your full name does not show on your current profile, you need to send it to us. We have almost 1,600 members, so you need to let us know which one you are. Thanks!

  • "PostgreSQL Indexing: How, Why, and When" with Curtis Maloney

    Thanks to Citus Data for hosting! Join us on February 19, 2019 as Curtis Maloney presents, "PostgreSQL Indexing: How, Why, and When". Curtis will present a basic introduction to how to apply indexes to your app, through an exercise in trying to improve performance of a simple discussion forum schema. About Curtis: I'm a long time Pythonista, early adopter of Django (and member of the Core Team since 2014) and recently took a role as a Data Engineer for a San Francisco based startup. Having been a web developer and consultant for the last 15 years or so, Postgres has been my go-to solution for data storage since I discovered it. RSVP NOTE: If your Meetup profile doesn't show your full name, please contact the organizers via Direct Message to give us your first and last name. We have to provide a list to the building for access. If you do not provide your full name, you will not be able to attend. Thanks!

    6
  • "ASSERTIONs in PostgreSQL" with David Fetter

    Thanks to Heap for hosting! David Fetter will present "ASSERTIONs in PostgreSQL". If you've ever bumped into the limits of what CHECK constraints can do, or think you might, this talk is for you. You'll learn about the very powerful next step in constraints: ASSERTIONs. You'll learn how to simulate them now with procedural code, and what you'll be able to do once they become available. David Fetter is a PostgreSQL contributor and advocate based in the San Francisco Bay Area. He helped found several organizations for computer professionals including the San Francisco Perl Users' Group and the San Francisco PostgreSQL Users' Group. RSVP NOTE: If your Meetup profile doesn't show your full name, please contact the organizers via Direct Message to give us your first and last name. We have to provide a list to the building for access. If you do not provide your full name, you will not be able to attend. Thanks!

    4
  • "Bi-Directional Replication for Postgres: A Multi-master Solution" - Mark Wong

    Note the earlier start time this month! Thanks to WeWork for hosting and to 2ndQuadrant for sponsoring! Mark Wong will present "Bi-Directional Replication for Postgres: A Multi-master Solution". BDR (bi-directional replication) enables asynchronous multi-master replication in Postgres as an extension and has been in full production status since 2014. We will discuss the use cases that BDR is most appropriate for, and where is might not be best suited. Mark works at 2ndQuadrant as a consultant for English Speaking Territories, based out of Oregon. He is a Contributor to PostgreSQL, co-organizer of the Portland PostgreSQL User Group, and serves as a Director and Treasurer for the United States PostgreSQL Association. RSVP NOTE: If your Meetup profile doesn't show your full name, please contact the organizers via Direct Message to give us your first and last name. We have to provide a list to the building for access. If you do not provide your full name, you will not be able to attend. Thanks!

    1