• Lightning Talks Extravaganza!
    This event was canceled.
  • "Optimizing Distinct Counts on PostgreSQL with HLL" with Sai Srirampur
    Thanks to Citus Data for hosting! Sai Srirampur, a solution architect for PostgreSQL and Citus databases, will present "Optimizing distinct counts on PostgreSQL with HLL". In this talk, we will focus on HyperLogLog (HLL) algorithm and its PostgreSQL extension postgresql-hll. HLL can provide approximate answers to COUNT(DISTINCT) queries in mathematically provable error bounds. HLL is not only fast and memory-efficient but also has very interesting properties which especially shine in a distributed environment. During the talk, first, we’ll look at the internals of the HLL. Then, we will look to understand why HLL algorithm is useful to get efficient pre-aggregations and distinct counts in scalable way. Finally, we will look at how HLL can be used in a distributed Postgres database cluster with Citus. 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!

    This Meetup is past

    CitusData

    599 3rd Street #301 · San Francisco, ca

    4 comments
  • "This One Goes to 11!" with Christophe Pettus of PGExperts
    Thanks to Heap for hosting! Christophe Pettus of PostgreSQL Experts will present "This One Goes to 11!" PostgreSQL version 11 will be out soon, and it has a huge list of new features, including: * DDL Improvements. * Partitioning Improvements. * Programing language Improvements. * Performance Improvements. * ... and lots of other stuff! Hear all about them in a detailed presentation of the latest and greatest version of PostgreSQL, now in beta! Christophe Pettus, CEO of PostgreSQL Experts, Inc., will be presenting. RSPV 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!

    This Meetup is past

    Heap

    225 Bush Street Second Floor · San Francisco, ca

  • "Modern PostgreSQL High Availability" with Alvaro Hernandez of OnGres
    We are delighted to present a second Meetup for July! Thanks to WeWork for providing space, and Ongres for hosting! Álvaro Hernandez of OnGres will present "Modern PostgreSQL High Availability". It’s 3am. Your phone rings. PostgreSQL is down, you need to promote a replica to master. Why the h**l isn’t this automatic? If you thought of this before, you want automatic High Availability (HA). Don’t miss this tutorial! We will enter the world of Modern PostgreSQL HA. Good news, there are several new, “modern” solutions for PostgreSQL HA. However, there are several solutions and it's not easy to pick one. Most require non-trivial setups, and there are many small caveats about HA like how to provide entry points to the application, HA correctness, HA vs. read scaling, external dependencies, interaction with cloud environments, and more! Álvaro is a passionate database and software developer. He has been an almost exclusive user of PostgreSQL, as THE database, for more than 15 years. Founder of OnGres, he is dedicated to R&D in databases. Álvaro founded ToroDB, previously the “Billion Tables Project” and keeps working on innovative open source solutions for databases, specially PostgreSQL. On his free time he also contributes to open source and PostgreSQL, like SCRAM's support in PostgreSQL's JDBC driver. He is a frequent speaker at PostgreSQL, database and Java conferences. Álvaro created the Spanish PostgreSQL user group, one of the largest in the world, with 800+ members. RSPV 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!

    This Meetup is past

    WeWork 156 2nd St

    156 2nd Street · San Francisco

    6 comments
  • "Automated Postgres Failover and Caching" with Roland Lee and Erik Brandsberg
    Thanks to npm Inc. for hosting! Roland Lee and Erik Brandsberg of Heimdall Data present "Automated Postgres Failover and Caching, with No Code Changes". Optimizing the performance and reliability of PostgreSQL can take intensive development work. In this session, we will discuss the concept of a Database Proxy, which provides performance visibility and control of SQL without coding. One such proxy is Heimdall Data which safely auto-caches into the cache of your choice (e.g. Redis, Elasticache, Hazelcast). We will also demonstrate how to implement failover (like PgPool-II) in minutes while adding automated caching for improved performance. Additional topics include 1) Analyzing query performance and 2) Read/write split (like PgBouncer) to leverage read-only servers. Supported databases include open source Postgres, Greenplum, and AWS Aurora without changes to existing applications. We will go over uses cases, view a demo, followed by Q&A. Come and join us for an interactive discussion. About the speakers: Roland Lee is VP of Products at Heimdall Data. His background is in application networking (Cisco, Citrix, Riverbed). He has been a developer and product manager in various startups and large companies. All through his career, his industry focus has been to increase the performance of Internet user data. Erik Brandsberg is CTO at Heimdall Data. He specializes in application-networking technologies for web and backend data. Whether it's coding, testing or installing, he has been involved. His diverse experience at Alteon, Citrix, and Juniper Networks gave him a solid understanding of operational complexities in a modern infrastructure. Doors open at 6:30 PM for socializing and food, and talks start at 7:00 PM.

    This Meetup is past

    npm, Inc.

    1999 Harrison St #1150 · Oakland, CA

    5 comments
  • "A Beginner's Tale of Migrating Column Types in PostgreSQL" with Belinda Adam
    This month, Belinda Adam presents, "A Beginner's Tale of Migrating Column Types in PostgreSQL". In June of last year, I entered "psql" into the command line for the first time, and by the end of the year, I had migrated a varchar(36) column on our largest production postgres table to a uuid column type. Our clients still rely on the case of this field, so I used an additional boolean column and SQLAlchemy's hybrid property to perform server-side serialization. In this talk, I'll walk you through the migration, challenges I ran into along the way, as well as some hard lessons I learned as someone totally new to PostgreSQL. Doors open at 6:30 PM for socializing and food, and talks start at 7:00 PM. Thanks to PlanGrid for hosting this month! PlanGrid is creating software for the 10 trillion dollar construction industry. Our mission is to be the record set for every job site in the world. Construction is stuck in the past - we are bringing it into the future through field first mobile applications enhanced by robust cloud-native APIs and advanced machine learning techniques. PlanGrid has adopted Python, React and Swift as our languages of choice for rapidly building advanced file processing pipelines and cloud services optimized for mobile offline use. THIS IS IMPORTANT: 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. You'll need to check in at the security desk in the main lobby before heading upstairs to the Meetup. ***If you don't give us your full name, you will not be on the access list, and you will not be able to attend.***

    This Meetup is past

    PlanGrid

    2111 Mission St #404 · San Francisco, CA

  • An Introduction to Using PostgreSQL with Docker & Kubernetes with Jonathan Katz
    Thanks to Chartboost for hosting this month! (Please note the earlier start; doors 6pm, talk 6:30pm for this meetup!) Our speaker this month is Jonathan Katz, the Director of Customer Success & Communications at Crunchy Data, a leading provider of trusted open source PostgreSQL technology, support, and training. Jonathan is also responsible for the advocacy efforts of the PostgreSQL Global Development Group, is a board member of the nonprofit United States PostgreSQL Association, and is a co-organizer of the NYC PostgreSQL User Group. The maturation of containerization platforms has changed how people think about creating development environments and has eliminated many inefficiencies for deploying applications. These concept and technologies have made its way into the PostgreSQL ecosystem as well, and tools such as Docker and Kubernetes have enabled teams to run their own “database-as-a-service” on the infrastructure of their choosing. All this sounds great, but if you are new to the world of containers, it can be very overwhelming to find a place to start. In this talk, we are going to show you how you can get PostgreSQL up and running in a container in your development environment using Docker, how it extends to a larger production environment with Kubernetes, and what the future holds for PostgreSQL in a containerized world. We will cover the following: *Why containers are important and what they mean for PostgreSQL *Setting up and managing a PostgreSQL container *Extending your setup with a pgadmin4 container *Container orchestration: What this means, and how to use Kubernetes to leverage database-as-a-service with PostgreSQL *Trends in the container world and how it will affect PostgreSQL At the conclusion of the talk, you will understand the fundamentals of how to use container technologies with PostgreSQL and be on your way to running a containerized PostgreSQL environment at scale! Doors open at 6:00 PM for socializing and food, and the talk starts at 6:30 PM. 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. You'll need to check in at the security desk in the main lobby before heading upstairs to the Meetup. Thanks!

    This Meetup is past

    Chartboost

    85 2nd Street, Ste 100 · San Francisco, CA

    7 comments
  • SFPUG April 2018 Meetup: Version 11!
    PostgreSQL version 11 has just had its feature freeze! We'll talk about what new things you can anticipate coming in PostgreSQL 11. Christophe Pettus, CEO of PostgreSQL Experts, Inc., will be presenting. Thanks to Neustar for hosting this month! Doors open at 6:30 PM for socializing and food, and talks start at 7:00 PM. 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. You'll need to check in at the security desk in the main lobby before heading upstairs to the Meetup. Thanks!

    This Meetup is past

    Neustar, Inc

    505 Howard St. #500 · San Francisco, CA

    3 comments
  • SFPUG March 2018 Meetup, East Bay Edition: PostgreSQL Locking
    This month, Quinn Weaver of PostgreSQL Experts will give an overview of PostgreSQL locking semantics, and offer a practical guide on techniques for to identifying (and fixing!) locking problems in your system, with examples of common problems and their mitigations. Thanks to Pandora for hosting! Doors open at 6:30 PM for food and socializing, talks begin at 7:00 PM.

    This Meetup is past

    Pandora

    2101 Webster Street 16th Floor Oakland, CA 94612 · Oakland, CA

    1 comment
  • Deep Dive into Amazon Aurora with PostgreSQL compatibility
    In February, we're pleased to have Jignesh Shah talk about Aurora! Amazon Aurora is a cloud-optimized relational database that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. The recently announced PostgreSQL-compatibility, together with the original MySQL compatibility, are perfect both for new application development and for migrations from overpriced, restrictive commercial databases. In this session, we’ll do a deep dive into the new architectural model and distributed systems techniques behind Amazon Aurora, discuss best practices and configurations, look at migration options, and share customer experiences from the field. Jignesh Shah is Product Manager for Amazon RDS with Amazon Web Services. At AWS, he works on PostgreSQL engines at AWS including Amazon RDS PostgreSQL and Amazon Aurora with PostgreSQL compatibility. He has worked with PostgreSQL since 2005 and has released application and database lifecycle products using PostgreSQL at appOrbit and VMware. He is an active member of the PostgreSQL community for a long time publishing a first standards accepted benchmark using PostgreSQL when he was at Sun Microsystems. His interests are in Cloud technologies involving Operating Systems, Containers and Databases. With gratitude to Entelo for hosting! Doors open at 6:30 PM for food and socializing, talk begins at 7:00 PM.

    This Meetup is past

    Entelo

    123 Mission, Suite 2400 · San Francisco, CA

    5 comments