- Conference - lists.ivorysql.org

ivorysql
by Thomas Liu June 7, 2025

June 7, 2025

(If you are NOT CEO, please kindly forward this to your CEO, because this is urgent. If you believe this has been sent to you in error, please ignore it. Thanks)Dear CEO,This email is from China domain name registration center, which mainly deal with the domain name registration in Shanghai, China. We received an application from Jiahai Ltd on June 7, 2025. They want to register "ivorysql" as their internet keyword and China (CN) domain names (ivorysql.cn, ivorysql.com.cn, ivorysql.net.cn, ivorysql.org.cn). But after checking it, we find this name conflict with your company name or trademark. In order to deal with this matter better, it's necessary to send email to you and confirm whether this company is your business partner in China? Best regardsThomas Liu General Manager Domain Registry Tel: +86-2161918696 Fax: +86-2161918697 Mob: +86-13816428671 12F Kaike Building, No. 1801 Hongmei Road, Shanghai 200233, China

1 0

HOW2025: Call for Speakers closed!
by Sessionize.com June 6, 2025

June 6, 2025

Hello, That was it! Call for Speakers for your HOW2025 event is now closed and session submissions are not possible. For late or celebrity speakers, you can use the "secret" link https://sessionize.com/how2025/?e=2dc186 [https://sessionize.com/how2025/?e=2dc186] And of course, you can always extend the Call for Papers by editing your event properties. 23 sessions have been submitted. Open your event [https://sessionize.com/app/organizer/event/19661] For next steps please consult our Smart Task List at the link above. Have fun choosing the best sessions for your event! Sessionize.com 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

1 0

New submission: PostgreSQL Optimizer Flaws: Real Stories and How We Fix Them
by HOW2025 June 6, 2025

June 6, 2025

Alena Rybakina has submitted a new session! PostgreSQL Optimizer Flaws: Real Stories and How We Fix Them The PostgreSQL optimizer usually does a solid job producing efficient query plans. But sometimes, it underestimates cardinality or misjudges query structure, leading to seriously inefficient plans and blown-out execution times. In this talk, we'll dive into some of the most unusual and surprising real-world cases where the optimizer got it wrong. We'll analyze the root causes behind these failures and walk you through how we tackled them — from the initial idea to real feature implementations like "OR-to-ANY Transformation" [0], "VALUES-to-ANY Transformation"[1], Replanning [2], and smart extensions like AQO [3], Switch Join [4], and more. You'll leave with a better understanding of how the optimizer works and where its weak spots are - plus fresh ideas on how to outsmart it. [0] https://github.com/postgres/postgres/commit/d4378c0005e61b1bb78e88097ea6efc… [https://github.com/postgres/postgres/commit/d4378c0005e61b1bb78e88097ea6efc…] [1] https://github.com/postgres/postgres/commit/c0962a113d1f2f94cb7222a7ca025a6… [https://github.com/postgres/postgres/commit/c0962a113d1f2f94cb7222a7ca025a6…] [2] https://habr.com/ru/companies/postgrespro/articles/819911/ [https://habr.com/ru/companies/postgrespro/articles/819911/] [3] https://www.pgevents.ca/events/pgconfdev2024/schedule/session/147-adaptive-… [https://www.pgevents.ca/events/pgconfdev2024/schedule/session/147-adaptive-…] [4] https://www.pgevents.ca/events/pgconfdev2025/callforpapers/346/ [https://www.pgevents.ca/events/pgconfdev2025/callforpapers/346/] Open session [https://sessionize.com/app/organizer/session/19661/950406] 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

1 0

New submission: Vacuum Performance Analysis Tools
by HOW2025 June 6, 2025

June 6, 2025

Alena Rybakina has submitted a new session! Vacuum Performance Analysis Tools Vacuum is one of the most critical processes in a database system. It prevents issues like table and index bloating and emergency freezes caused by transaction ID wraparound. It also keeps the visibility map up to date. However, improperly tuned autovacuum settings can lead to excessive resource consumption, causing queries across the system to slow down. Database administrators must carefully adjust autovacuum parameters to balance the benefits of vacuuming with its overhead. Today, administrators typically rely on basic statistics, like the number of vacuum passes over tables or real-time data from pg_stat_progress_vacuum. But these metrics are limited — they’re only available during vacuum operations and don’t offer a strategic, long-term view. I’d like to explain our mechanism for collecting detailed information about vacuum resource consumption for both tables and indexes [0]. This data is stored in the Cumulative Statistics System on a per-relation basis — meaning for each table and each index. It can be analyzed using monitoring tools like pg_profile [1]. pg_profile is a PostgreSQL extension that captures query statistics and snapshots them over time, helping to identify and troubleshoot server performance bottlenecks. I’ll demonstrate how these new vacuum counters can give you a clearer, object-level view of vacuum activity in your database and help guide more effective autovacuum configuration. [0] https://www.pgevents.ca/events/pgconfdev2025/callforpapers/374/ [https://www.pgevents.ca/events/pgconfdev2025/callforpapers/374/] [1] https://github.com/zubkov-andrei/pg_profile/tree/master [https://github.com/zubkov-andrei/pg_profile/tree/master] Open session [https://sessionize.com/app/organizer/session/19661/950384] 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

1 0

New submission: From Tables to Trees - The Expanding Graph Ecosystem in PostgreSQL
by HOW2025 June 5, 2025

June 5, 2025

Umar Hayat has submitted a new session! From Tables to Trees - The Expanding Graph Ecosystem in PostgreSQL I will discuss past, present and future of Graph ecosystem in PostgreSQL. Brief about graph projects AgensGraph, Apache AGE and PostgreSQL community development. On going development in standards conformance SQL/PGQ and ISO/GQL and relevance with AI. Open session [https://sessionize.com/app/organizer/session/19661/949969] 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

1 0

Social banners for HOW2025
by Sessionize.com June 3, 2025

June 3, 2025

The files you have requested are ready for download! Download [https://sessionize.com/package-download/20250603-211739-8ee4501f347546db84a…] 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

1 0

Re: Your session YDB: extending a Distributed SQL DBMS with PostgreSQL compatibility has been accepted
by Ivan Blinkov May 29, 2025

May 29, 2025

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

1 0

New submission: Monitoring PgVector RAG Agents Applications
by HOW2025 May 27, 2025

May 27, 2025

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

1 0

Social banners for HOW2025
by Sessionize.com May 27, 2025

May 27, 2025

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

1 0

Re: Cédric's flights to/from Beijing
by Grant Zhou May 26, 2025

May 26, 2025

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

1 0