- JSONB and When not to use JSONB + PostgresConf recap
Join us on Wednesday the 24th for a recap and highlights of PostgresConf 2019 as well as a fantastic presentation from Anson Abraham on When to use JSONB and When not to use JSONB! The technical presentation is a use case of using JSONB in Postgres, when it works and when it really does not fit your model and you will need to work within another document store. We will also cover using an FDW to access the other document store from Postgres.
- Winter Event with NYC Postgres, PostgresConf and Timescale!
Join NYC Postgres, PostgresConf, and Timescale at the annual NYC Postgres Winter Party! Set right after the holiday rush, this is the perfect opportunity to catch up with the community, share some food, and network with other People, Postgres, Data lovers in NYC!
- Understanding Query Plans Using EXPLAIN
2018 is drawing to a close and we've had an exciting year of PostgreSQL meetups! Before we kick off 2019, we thought we could get in one more meetup to cover an important topic in PostgreSQL world - how to figure out what our query is doing! One of the most complex parts of the PostgreSQL system is the planner and the optimizer. This talk will help you understand what happens when you ask the database to execute a query on your behalf. We will go over EXPLAIN, EXPLAIN ANALYZE, other ways of running EXPLAIN, how to adjust parameters to view alternative possible plans, and what the output and results mean. Join us as Stephen Frost, a PostgreSQL Major Contributor, CTO of Crunchy Data, and a past speaker at NYCPUG, teach us how to use EXPLAIN to write better queries! We will be at the offices of Pivotal on 636 6th Ave (entrance on 19th St). Please go to the 2nd Floor. Agenda: 6:30pm - 6:50pm - Food & Networking 6:50pm - 8:10pm - Main Event 8:10pm - Meet up at...
- Secure PostgreSQL 11 Deployments
PostgreSQL 11 was released on October 18, 2018, which means everyone is currently in the process upgrading to the new major version (right? ;-) Well, even if you're not immediately moving to PostgreSQL 11, you may be looking to deploy it into a production environment, and chances are, you probably have some security requirements as well. Magnus Hagander, a longtime PostgreSQL Major Contributor, Core Team member, and past NYCPUG speaker, would like to share with us on how to securely deploy PostgreSQL and cover some of the new security features available in PostgreSQL 11 as well. Some topics will include: • Securing the PostgreSQL infrastructure and runtime environment • Securing the channel between client and server using SSL, including an overview of the threats and how to secure against them • Understanding how to secure the login process and more. Join us on Tuesday, November 13, 2018 at 6:30pm at the offices of Goldman Sachs at 200 West St for another fun and informative NYCPUG event! Agenda: 6:30pm - 6:50pm - Networking 6:50pm - 6:55pm - Introductions 6:55pm - 8:00pm - Main Event: Magnus Hagander, Secure PostgreSQL 11 Deployments Instructions for Building Entry: You must bring photo ID to enter 200 West Street. Please ensure your ID name matches registered your name as it appears on Meetup.com - If it does not, please provide your name as it appears on your ID to Jonathan Katz by Monday November 12. Location: Please enter 200 West Street, New York NY at the main entrance at the corner of Vesey and West Street. This is the entrance closest to the World Trade Center. Upon arrival, proceed to the security desk and present your photo ID. Attendee passes will be pre-printed for faster processing if you were not a late RSVP. Security can contact Bryan Doyle in case of any issues faced during this process. Once you enter the lobby, proceed North to the “sky lobby” elevator bank. There are about 8 elevators and they all only stop at Floor 11. There will be signs directing you to this elevator bank. Once you exit the elevator bank, proceed up the spiral staircase to floor 12, which is the conference center (there is an elevator to this floor available as well). There will be an additional signage directing you to this prominent staircase. Once you are on the conference center floor (floor 12), please proceed only to Rooms[masked]. Pizza and Cold Soft Beverages will be served starting for networking at 6:30pm.
- An evening with Postgres
Event schedule 06:30 - doors open, food/beverages 07:00 - introductions 07:10 - Seth Rosenblum: Monitoring at DataDog 07:30 - Bruce Momjian: Will Postgres Live Forever 08:20 - Matvey Arye: Building a Performant Time-Series Database 08:40 - close As a co-founder and core team member of the Postgres open-source project, Bruce Momjian is in a unique position to discuss its long history, and give some insights into the future of the project. In a sweeping presentation, Bruce will discuss what keeps open-source projects alive and vibrant, and how the future of databases will be open-source first, and Postgres first because it's the only database that satisfies the myriad requirements of businesses and startups. Come with your questions, or just come to listen. We have a great evening planned, with additional Postgres talks by DataDog and Timescale. Talk: Will Postgres Live Forever Speaker: Bruce Momjian, co-founder and core team member of the PostgreSQL Global Development Group and Sr. Database Architect at EnterpriseDB. http://momjian.us/
- Bruce Momjian: What's New in PostgreSQL 11?
It's that time - the new version of PostgreSQL is being released, and we can already tell PostgreSQL 11 is going to be big! With improvements to the partitioning system, SQL procedures, more parallelized queries, and more, there are a whole trove of features to improve your PostgreSQL experience. Also in annual NYCPUG tradition, we will be having Bruce Momjian, a PostgreSQL Core Team Member and one of the original members of the project, come and tell us "What's New in PostgreSQL 11." Join us for a very informative evening and starting making plans to upgrade! (Especially if you're on 9.3 or earlier!). Agenda: 6:30 - 6:50 - Food & Networking 6:50 - 8:00 - Bruce Momjian - What's New in PostgreSQL 11? 8:00 - Grab a drink at...
- PostgreSQL with Apache Ignite: Faster Transactions and Analytics
Schedule for tonight: 06:30 - doors open, drinks & pizza 07:00 - introduction 07:15 - main presentation "PostgreSQL with Apache Ignite: Faster Transactions and Analytics." Speaker: Akmal Chaudhri, Phd, Apache Ignite's technology evangelist. The 10x growth of transaction volumes, 50x growth in data volumes -- along with the drive for real-time visibility and responsiveness over the last decade -- have pushed traditional technologies including databases beyond their limits. Your choices are either to buy expensive hardware to accelerate the wrong architecture, or do what other companies have started to do and invest in technologies being used for modern hybrid transactional/analytical processing (HTAP). Combining Apache Ignite with PostgreSQL can offer enterprises the best of both open-source worlds: a highly-scalable high-velocity grid-based in-memory SQL database, with a robust fully-featured SQL persistent datastore for advanced analytics and data-warehouse capabilities. Apache Ignite is the leading open source database, caching and processing platform. As an In-Memory Data Grid (IMDG), Apache Ignite can be inserted between an application and existing database, such as an RDBMS or NoSQL, to provide speed, scale, and high availability. Topics to be covered: * How to complement PostgreSQL for Hybrid Transactional/Analytical Processing (HTAP) by leveraging the massive parallel processing and SQL capabilities of Apache Ignite. * How to use Apache Ignite as an In-Memory Data Grid that stores data in memory and boosts applications performance by offloading reads from PostgreSQL. * The strategic benefits of using Apache Ignite instead of Memcache, Redis, GigaSpaces, or Oracle Coherence. Akmal Chaudhri is a Technology Evangelist at GridGain. His role is to help build the global Apache Ignite community and raise awareness through presentations and technical writing. He has over 25 years experience in IT and has previously held roles as a developer, consultant, product strategist and technical trainer. He has worked for several blue-chip companies such as Reuters and IBM, and also the Big Data startups Hortonworks (Hadoop) and DataStax (Cassandra NoSQL Database). He has regularly presented at many international conferences and served on the program committees for a number of major conferences and workshops. He has published and presented widely and edited or co-edited 10 books. He holds a BSc (1st Class Hons.) in Computing and Information Systems, MSc in Business Systems Analysis and Design and a PhD in Computer Science. He is a Member of the British Computer Society (MBCS) and a Chartered IT Professional (CITP).
- Essential PostgreSQL Performance Tuning
Curious about how to tune PostgreSQL and your Linux kernel to get the best performance out of your database? Come join Payal Singh of OmniTI as she delivers a practical guide to optimizing your database's environment for its workload. "Essential PostgreSQL Performance Tuning" Looking at the list of kernel and postgresql.conf parameters, tuning your PostgreSQL database may seem like a daunting task. While each parameter has a role to play, in most scenarios just a handful of these end up impacting performance the most. This talk aims to be a quick practical guide to tuning your PostgreSQL cluster to get the best possible performance with the least effort, with special emphasis on kernel tuning. Along the way we will look at the most commonly encountered gotchas when setting up a new PostgreSQL cluster or migrating an existing one. Also discussed are approaches for performance comparison and a brief look at automated tuning tools. Agenda: July 26, 2018 - At Knotel (1 State St, 26th Flr, New York, NY 10004) 6:30 - 6:50pm - Networking 6:50 - 7:00pm - Introductions 7:00pm - The Main Event! 8:15pm - Grab drinks at...
- An Exploration on Using PostgreSQL Dates and Times in Applications