May 2025 - Conference - lists.ivorysql.org

Re: Your session YDB: extending a Distributed SQL DBMS with PostgreSQL compatibility has been accepted

by Ivan Blinkov

Hi Grant, - +66805508077 - Attached - 50140, 40 Moo 8, Khua Mung, Saraphi, Chiang Mai, Thailand - I'll likely fly in directly to Jinan: SC8076 on 26th, SC8075 on 29th -- Ivan On Wed, May 28, 2025 at 1:04 AM GRANT ZHOU <grantzhou(a)gmail.com> wrote: > Hello Ivan, > > Welcome aboard! Please send us the following information for your > invitation letter: > > Please email conference(a)ivorysql.org with: > > - Your contact phone number > - Copy of your passport's first page > - Your address and other relevant travel details > > Best regards, > Grant > > On Tue, May 27, 2025 at 1:18 AM Ivan Blinkov <ivan(a)blinkov.ru> wrote: > >> Hi, >> >> Thank you for accepting the proposal! Could you provide an invitation >> letter for the visa application? >> >> On Tue, May 27, 2025 at 1:44 PM HOW2025 <how2025(a)events.sessionize.com> >> wrote: >> >>> Well done, Ivan! >>> >>> We’re excited to let you know that your session "YDB: extending a >>> Distributed SQL DBMS with PostgreSQL compatibility" has been accepted for >>> HOW2025! >>> >>> Please click on the link below to acknowledge that you have received >>> this message and you'll be joining us! >>> >>> 👉 Confirm participation >>> <https://sessionize.com/app/speaker/session/confirmStatus/929813/imgakyec> >>> >>> If you cannot attend, or have any questions, please reply to this >>> message. >>> >>> >>> 📍Venue Update >>> >>> You can find the latest venue details and travel info here: >>> >>> https://ivorysql.io/venue/ >>> >>> >>> Any thing needs our support, please let us know. >>> >>> >>> Thanks, >>> HOW2025 >>> >>> conference(a)ivorysql.org >>> >>> Tip: You've used Google (iv***(a)***inkov.ru) to login. >>> >>> You're receiving this message because you had joined event 'HOW2025' on >>> Sessionize. >>> >>> Sessionize.com, PO Box 6945, Unit 34564, London W1A 6US, UK >>> >> >> >> -- >> Ivan Blinkov >> > -- Ivan Blinkov

May 29, 2025

New submission: Monitoring PgVector RAG Agents Applications

by HOW2025

Jayita Bhattacharyya has submitted a new session! Monitoring PgVector RAG Agents Applications pgvector within Retrieval-Augmented Generation (RAG) agents. As pgvector integrates vector similarity search capabilities into PostgreSQL, ensuring optimal performance and reliability in RAG workflows is crucial. Proposals should address:Performance Monitoring: Techniques for tracking and analyzing pgvector query performance, including latency, throughput, and resource utilization. Utilizing PostgreSQL's built-in tools like EXPLAIN and ANALYZE can be beneficial. Error Detection and Debugging: Methods to identify and resolve errors or anomalies in pgvector operations within RAG applications. Implementing observability tools can aid in monitoring and debugging complex RAG-based systems. Scalability and Resource Management: Strategies to monitor and manage resource allocation, ensuring efficient scaling of pgvector in RAG contexts. Scaling pgvector can be achieved by increasing memory, CPU, and storage on a single instance, or by using replicas and sharding techniques. Integration with Observability Tools: Approaches to incorporate existing observability platforms for comprehensive monitoring of pgvector within RAG pipelines. Tools like New Relic offer observability quickstarts for pgvector, providing dashboards and alerts to monitor key performance metrics. Open session [https://sessionize.com/app/organizer/session/19661/942397] These notifications can be turned off on Edit event [https://sessionize.com/app/organizer/event/edit/19661#_tab-advanced] page. Tip: You've used Classic (confer***(a)***orysql.org) to login. You're receiving this message because you had joined event 'HOW2025' on Sessionize. Sessionize.com, PO Box 6945, Unit 34564, London W1A 6US, UK

May 27, 2025

Social banners for HOW2025

by Sessionize.com

The files you have requested are ready for download! Download [https://sessionize.com/package-download/20250527-070918-8117481f00d34fe8a01…] Please note that files are available for 24 hours only. Enjoy! Tip: You've used Classic (confer***(a)***orysql.org) to login. You're receiving this message because you had joined event 'HOW2025' on Sessionize. Sessionize.com, PO Box 6945, Unit 34564, London W1A 6US, UK

May 27, 2025

Re: Cédric's flights to/from Beijing

by Grant Zhou

Hi Andrea and Cédric, Thank you for confirming the date and flight details. I'm excited to see you both next month and will keep you posted on updates regarding your visit to China over the next few days. Best regards, Grant > On May 25, 2025, at 1:15 PM, Andrea Cucciniello <andrea.cucciniello(a)data-bene.io> wrote: > > Hi all, > > Just to confirm, I’ll be arriving on June 26th at 5:35am on Air China flight CA846 to Beijing, and flying back to Barcelona on July 2nd at 2:50am on flight CA845. > > Unfortunately, I won’t be able to stay longer, so July 1st will be my only day to visit the Great Wall or explore a bit of the city. > > Looking forward to meeting you all there! > > Best, > Andrea > > > On 24/5/25 09:07, Cédric Villemain wrote: >> Hi Grant, >> >> I hope you're doing well since this very nice dinner in Montreal. >> >> This message to let you know that I: >> >> * arrive in Beijing from Paris with Air France "AF0202" on the 26/06, at 3.55pm >> * leave from Beijing to Paris with Air France "AF0201" on the 02/07, at 11.05pm. >> >> Thank you so much for all the details and suggestions you provided, I hope to benefit full day of tourism in Beijing area on the 2nd of July too. >> >> >> Enjoy your week-end, >> >> --- >> Cédric Villemain +33 6 20 30 22 52 >> https://www.Data-Bene.io <https://www.data-bene.io/> >> PostgreSQL Support, Expertise, Training, R&D Highgo Software (Canada) www.highgo.ca 9850 King George Blvd suite 300, Surrey, BC V3T 4Y3

May 26, 2025

New submission: What is Patroni, really?

by HOW2025

Alexander Kukushkin has submitted a new session! What is Patroni, really? Patroni is widely recognized as a high-availability solution for PostgreSQL—but what really makes it tick? In this talk, we’ll explore its architecture, core principles, and the clever mechanisms that keep it resilient in production. We’ll go beyond the documentation to uncover the design decisions—both brilliant and painful—that shaped Patroni into what it is today. We’ll also touch on the practical challenges that come with deploying Patroni in real-world environments: choosing and managing distributed configuration systems like Etcd or Consul, handling backups and point-in-time recovery, managing PostgreSQL configuration, and integrating tools like pgbouncer. These are the kinds of questions that regularly surface in the community and define what it means to run Patroni in production. Open session [https://sessionize.com/app/organizer/session/19661/939959] These notifications can be turned off on Edit event [https://sessionize.com/app/organizer/event/edit/19661#_tab-advanced] page. Tip: You've used Classic (confer***(a)***orysql.org) to login. You're receiving this message because you had joined event 'HOW2025' on Sessionize. Sessionize.com, PO Box 6945, Unit 34564, London W1A 6US, UK

May 25, 2025

New submission: Switching to Open: Why PostgreSQL and IvorySQL Make Business Sense

by HOW2025

Andrea Cucciniello has submitted a new session! Switching to Open: Why PostgreSQL and IvorySQL Make Business Sense This non-technical talk explores the business and operational case for adopting open-source databases, with a focus on PostgreSQL and IvorySQL.I’ll share how we at Data Bene help organisations transition from proprietary systems, and how open-source adoption fits into a broader strategic and commercial framework. IvorySQL plays a key role in our customer journey model, particularly for Oracle compatibility. Open session [https://sessionize.com/app/organizer/session/19661/938679] These notifications can be turned off on Edit event [https://sessionize.com/app/organizer/event/edit/19661#_tab-advanced] page. Tip: You've used Classic (confer***(a)***orysql.org) to login. You're receiving this message because you had joined event 'HOW2025' on Sessionize. Sessionize.com, PO Box 6945, Unit 34564, London W1A 6US, UK

May 23, 2025

New submission: Stats roll, baby, stats roll.

by HOW2025

Cédric Villemain has submitted a new session! Stats roll, baby, stats roll. PostgreSQL 18 will offer extension developers support for defining new statistics, using the native PostgreSQL Cumulative Statistics. We're talking about stats similar to what's in `pg_stat*` views and functions, and how you will be able to define your own views and functions in the future. Using the PACS (PostgreSQL Advanced Cumulative Statistics) extension, we will explore what is offered by PostgreSQL as well as how to define your own new kind of statistics. We will also see how to benefit from the C and SQL API provided by PACS to setup your own gauge, counters, buckets and histogram. Open session [https://sessionize.com/app/organizer/session/19661/938219] These notifications can be turned off on Edit event [https://sessionize.com/app/organizer/event/edit/19661#_tab-advanced] page. Tip: You've used Classic (confer***(a)***orysql.org) to login. You're receiving this message because you had joined event 'HOW2025' on Sessionize. Sessionize.com, PO Box 6945, Unit 34564, London W1A 6US, UK

May 22, 2025

New submission: Resource Control Admission - I have a date with my PSI

by HOW2025

Cédric Villemain has submitted a new session! Resource Control Admission - I have a date with my PSI Pressure Stall Information (PSI) has been present in Linux for numerous years, but even so, it's not well known in the world of PostgreSQL. In this talk, we'll introduce PSI along with what it brings, how it works, and where it is used today. Then, we will use the `pg_psi` extension to start "playing" with PSI and react to system events. To do this, we will define system triggers so we're notified when the server is slowing down. This gives us the chance to adjust the workload before it's too late, or give more resources to background tasks like auto-vacuum when it's possible. Open session [https://sessionize.com/app/organizer/session/19661/938217] These notifications can be turned off on Edit event [https://sessionize.com/app/organizer/event/edit/19661#_tab-advanced] page. Tip: You've used Classic (confer***(a)***orysql.org) to login. You're receiving this message because you had joined event 'HOW2025' on Sessionize. Sessionize.com, PO Box 6945, Unit 34564, London W1A 6US, UK

May 22, 2025

New submission: Spat: Hijacking Shared Memory for a Redis-Like Experience in PostgreSQL

by HOW2025

Florents Tselai has submitted a new session! Spat: Hijacking Shared Memory for a Redis-Like Experience in PostgreSQL Databases traditionally use shared memory as a transient workspace for query execution, caching, and transaction management, hidden from direct user control. But what if we could repurpose it for user-facing, high-performance data structures and general caching? In this session, I’ll explore PostgreSQL’s shared memory APIs available to extension developers, including recent features like the DSM Registry. I’ll introduce Spat, a Redis-like in-memory data structure server embedded within PostgreSQL, where data is stored entirely in shared memory. Spat provides an extended key-value model in which keys are strings, and values can be strings, lists, sets, or hashes. This offers a fast, lightweight alternative for ephemeral storage inside PostgreSQL. This talk will explore the technical challenges and opportunities of using shared memory beyond its traditional scope, providing ideas for anyone interested in extending PostgreSQL. Open session [https://sessionize.com/app/organizer/session/19661/937793] These notifications can be turned off on Edit event [https://sessionize.com/app/organizer/event/edit/19661#_tab-advanced] page. Tip: You've used Classic (confer***(a)***orysql.org) to login. You're receiving this message because you had joined event 'HOW2025' on Sessionize. Sessionize.com, PO Box 6945, Unit 34564, London W1A 6US, UK

May 22, 2025

New submission: Doing More with JSONPath: Turning a Query Language into a Transformation Engine

by HOW2025

Florents Tselai has submitted a new session! Doing More with JSONPath: Turning a Query Language into a Transformation Engine PostgreSQL’s JSONPath engine is often seen as just a filtering tool — but its real potential lies much deeper. In this talk, we’ll explore how the JSONPath infrastructure can serve as a foundation for building powerful, domain-specific languages (DSLs) within Postgres. Drawing on my recent work to extend JSONPath with richer text processing functions like lower(), replace(), we’ll demonstrate how these additions evolve JSONPath from a query language into a lightweight transformation engine. You’ll learn:• How JSONPath is implemented in PostgreSQL and why it’s extensible• The design rationale behind adding composable text functions to the language• How these functions open the door to expressive, pipeline-style data transformations• Why JSONPath’s AST and evaluation model make it a great blueprint for custom DSLs If you’re interested in Postgres internals, building smarter queries, or embedding logic closer to the data — this is your invitation to rethink what JSONPath can do. Open session [https://sessionize.com/app/organizer/session/19661/937792] These notifications can be turned off on Edit event [https://sessionize.com/app/organizer/event/edit/19661#_tab-advanced] page. Tip: You've used Classic (confer***(a)***orysql.org) to login. You're receiving this message because you had joined event 'HOW2025' on Sessionize. Sessionize.com, PO Box 6945, Unit 34564, London W1A 6US, UK

May 22, 2025