talk-data.com
People (1 result)
Activities & events
| Title & Speakers | Event |
|---|---|
|
PostgreSQL Performance Fundamentals
2025-09-30 · 22:00
Please join us for a night of PostgreSQL! PostgreSQL is awesome - and out of the box performance could certainly be customized! In this talk\, we’ll dig into the key fundamentals for PostgreSQL performance. We’ll approach this from two angles - first memory cache and data management. There are a couple tricks for getting the most out of PostgreSQL memory without throwing more RAM (and money) at the problem. Second, we’ll look at PostgreSQL’s internal EXPLAIN tools to diagnose issues with queries, test improvements, and make your queries faster. You’ll leave this talk with a better grasp on what helps PostgreSQL perform and how to get started on your own performance improvements. RSVP details: This meetup will be held at the Snowflake Manhattan Office at 114 West 40th Street, NY, NY 10018. Building security will require a complete list of RSVPs more than 24 hours ahead of time. Space is strictly limited at 30 guests so please change your RSVP if you cannot make it. Guests will be registered in the system via email and must fill out a check in form. At the time of the event, guests will check in and present identification to lobby security, and then be let up to the meeting suite. Please specify your dietary needs in the RSVP form as well so we can plan the food accordingly. Details: Tuesday, September 30th. 6-7:30pm Snowflake Manhattan Office at 114 West 40th Street Snacks and drinks will be served Sponsor: Snowflake Additional Info: This is our first meeting after a very long break and we are so excited to meet and kickstart our group again. If you have ideas for future group spaces, events, or talks - please reach out. This group is open to anyone interested in PostgreSQL and we welcome speakers and attendees at all points in their data careers. |
PostgreSQL Performance Fundamentals
|
|
Learn PostgreSQL - Second Edition
2023-10-31
Enrico Pirozzi
– author
,
Luca Ferrari
– author
Learn PostgreSQL, a comprehensive guide to mastering PostgreSQL 16, takes readers on a journey from the fundamentals to advanced concepts, such as replication and database optimization. With hands-on exercises and practical examples, this book provides all you need to confidently use, manage, and build secure and scalable databases. What this Book will help me do Master the essentials of PostgreSQL 16, including advanced SQL features and performance tuning. Understand database replication methods and manage a scalable architecture. Enhance database security through roles, schemas, and strict privilege management. Learn how to personalize your experience with custom extensions and functions. Acquire practical skills in backup, restoration, and disaster recovery planning. Author(s) Luca Ferrari and Enrico Pirozzi are experienced database engineers and PostgreSQL enthusiasts with years of experience using and teaching PostgreSQL technology. They specialize in creating learning content that is practical and focused on real-world situations. Their writing emphasizes clarity and systematically equips readers with professional skills. Who is it for? This book is perfect for database professionals, software developers, and system administrators looking to develop their PostgreSQL expertise. Beginners with an interest in databases will also find this book highly approachable. Ideal for readers seeking to improve their database scalability and robustness. If you aim to hone practical PostgreSQL skills, this guide is essential. |
|
|
Baji Shaik
– author
,
Dinesh Kumar Chemuduru
– author
Learn the fundamentals of PL/PGSQL, the programming language of PostgreSQL which is most robust Open Source Relational Database. This book provides practical insights into developing database code objects such as functions and procedures, with a focus on effectively handling strings, numbers, and arrays to achieve desired outcomes, and transaction management. The unique approach to handling Triggers in PostgreSQL ensures that both functionality and performance are maintained without compromise. You'll gain proficiency in writing inline/anonymous server-side code within the limitations, along with learning essential debugging and profiling techniques. Additionally, the book delves into statistical analysis of PL/PGSQL code and offers valuable knowledge on managing exceptions while writing code blocks. Finally, you'll explore the installation and configuration of extensions to enhance the performance of stored procedures and functions. What You'll Learn Understand the PL/PGSQL concepts Learn to debug, profile, and optimize PL/PGSQL code Study linting PL/PGSQL code Review transaction management within PL/PGSQL code Work with developer friendly features like operators, casts, and aggregators Who Is This Book For App developers, database migration consultants, and database administrators. |
|
|
Learning PostgreSQL 11 - Third Edition
2019-01-31
Christopher Travers
– author
,
Andrey Volkov
– author
Immerse yourself in the capabilities of PostgreSQL 11 with this comprehensive beginner's guide. Learning PostgreSQL 11 will take you through relational database fundamentals and advanced database functionality, empowering you to build efficient and scalable database solutions with confidence. By the end of this book, you'll have mastery over PostgreSQL's features to develop, manage, and optimize your own databases. What this Book will help me do Gain a solid understanding of relational database principles and the PostgreSQL ecosystem. Learn to install PostgreSQL, create a database, and design a data model effectively. Develop skills to create, manipulate, and optimize tables, views, and efficient indexes. Utilize server-side programming with PL/pgSQL and advanced data types like JSONB. Enhance database reliability and performance, and connect to your Python applications seamlessly. Author(s) Christopher Travers and None Volkov bring their collective expertise and practical experience to this book. Christopher has a strong background in software development and database systems, with years of hands-on involvement with PostgreSQL. None has contributed significantly to innovative database solutions, emphasizing clear and actionable instructions. Together, they aim to demystify PostgreSQL for learners of all backgrounds. Who is it for? This book is crafted for developers, database administrators, and tech enthusiasts who want to delve into PostgreSQL. Beginners with no prior database experience will find its approach accessible, while those aiming to enhance their skills with PostgreSQL's latest features will benefit immensely. It's ideal for anyone seeking to build solid database or data warehousing applications with modern capabilities and best practices. |
|