PostgreSQL.TW

彙整國際上PostgreSQL應用與服務案例

講者

林宗禧

自PostgreSQL 9 成為重度使用者，初以開發FDW 為樂；於2014-2016 間，約兩年半的時間，聯繫拜訪國內推廣PostgreSQL 的前輩，以及聚集相關技服廠商，自2017 年再次推動台灣PostgreSQL使用者社群(TWPUG) ；目前著重發展PostgreSQL 為核心的Data Application Platform，並推廣在各類產業應用。

Every so often, one may be called upon to perform the tasks of a database administrator, especially in cases where application performance seems to be affected by the database. This talk will give non-DBAs an insight into how the world’s most powerful open-source database works, and the kind of tools and features that are readily available for people who unexpectedly find themselves in the DBA pilot’s seat. Topics covered will include query tuning, monitoring, indexing, and a basic run-down of some configurables to help you know what options are at your disposal

講者

Richard Yen

Richard has been using PostgreSQL since v. 7.4 in 2003. He is a Principal Software Engineer and Support Engineer at EnterpriseDB, providing technical support to DBAs and developers around the world, and works with many clients ranging from private corporations to government organizations and financial institutions.

PostgreSQL is the world's most powerful open-source database. Testing it out does not have to be a scary or risky experience. Learn how to use it without making severe changes to your applications.

講者

Richard Yen

Richard has been using PostgreSQL since v. 7.4 in 2003. He is a Principal Software Engineer and Support Engineer at EnterpriseDB, providing technical support to DBAs and developers around the world, and works with many clients ranging from private corporations to government organizations and financial institutions.

介紹 PostgreSQL 的生態： PL/Python, PL/Rust, Function, Trigger, TimescaleDB, pg_cron, PostgREST 打造海克力斯專案

講者

鍾明達

一位系統開發的工程師

講者

張友謙

已經在Coscup講PG很多次了.

講者

孫菖鴻

我是Eagle(老鷹），是一個PHP與PostgreSQL 的使用者，喜歡分享與研究PostgreSQL的技術。

This talk discusses challenges of storing petabytes of log data in PostgreSQL and some of their potential solutions. PostgreSQL itself doesn't have everything you might need for a transactional processing distributed database, but it is remarkably capable in other areas. This talk provides one example.

講者

Chris Travers

Chris Travers has over 25 years of experience with PostgreSQL and other open source technologies. He has worked as a software developer and engineer, database administrator, engineering manager, and consultant. He formerly lead both the platform teams (using Gentoo Linux) and the database teams (using PostgreSQL) at Adjust. He has also contributed to a variety of open source projects including PostgreSQL.

A vector database is a database system based on vectors, which focuses on storing and querying high-dimensional data, especially vector-type data. In this session, we'll introduce how to utilize PostgreSQL extensions to achieve the functionality of a vector database.

講者

CHIN SHEN FANG

Enjoy playing musical instruments and studying history. Currently, worked as a backend engineer now.

Unleash the potential of PostgreSQL! It can handles complex workloads, i.e. HTAP, combining OLTP as well as OLAP. Needless to say, this is an open source adoption. In this session, I will share how to extend PostgreSQL into a column-oriented store that can compress and scale horizontally while efficiently handling OLAP. Let's learn about HTAP, which is becoming a trend in databases.

講者

Takahiro Kobayashi

Database Technical Lead at NTT Data. He is instrumental in talking with engineers about PostgreSQL and distributed databases and setting up meetups. He is a speaker at PGConf.Asia 2019 and PostgreSQL Conference Japan 2023, and is the Japanese translation supervisor for O'Reilly's Database Internals.

介紹 PostgreSQL Logical Decoding 與 Replication 概念並透過 pgcapture - CDC (Change Data Capture) framework 來展示其應用。

講者

Kenny Chen - 肯尼工程師

喜歡研究 PostgreSQL、Golang 等相關後端技術，也熱衷經營部落格並撰寫技術文章。

PoWA is a postgres-centric and extensible workload analyzer that gives a broad overview of what is happening on a postgres server and its various subsystems.

If you hit a performance problem on your database, PoWA can tell you why!

講者

Julien Rouhaud

Julien is a PostgreSQL Major Contributor. He has been working with PostgreSQL since verson 8.3, as a developer and a DBA. He has many contribution to PostgreSQL itself. He's also the author of other open source projects such as PoWA (real-time performance diagnosis) and HypoPG (hypothetical indexes).

He’s also a former treasurer of the PostgreSQL Europe association.

In this session, I will introduce my experiences about interacting between PostgreSQL and ClickHouse. It includes multiple approaches about how these two different types of databases can interact with each other. I also provide some real-world cases to demonstrate above interacting situations.

講者

Peter

My name is Peter Li, I developed many open source projects and I also keen on contributing/collaborating many open source projects in the GitHub for about six years.

In the past, I worked as a associate engineer in Industrial Technology Research Institute and I research the electric and energy application systems.

Now I worked as a associate engineer in Institute for Information Industry and I research the medical information and carbon emission domains.

PostgreSQL is an implementation of SQL standard with one of the most vibrant ecosystems around it. To leverage all the tools and libraries that already know how to work with PostgreSQL, emerging database management systems that bring something new to the market need to learn how to mimic PostgreSQL. This talk explores possible approaches to this and related trade-offs, as well as reasoning why YDB chose a unique approach to bring serializable consistency and seamless scalability to the PostgreSQL ecosystem.

講者

Ivan Blinkov

Ivan Blinkov is a seasoned technical leader specializing in data storage and processing. Over the last decade, he was involved in the development of several database management systems, two of which are open-source: ClickHouse in the past and, more recently, YDB.

This presentation highlights a backend engineer's journey in optimizing financial data analysis by advancing from basic CRUD operations to sophisticated SQL features. Faced with the challenge of slow API responses due to extensive database interactions, a novel approach was adopted—transferring computational processes directly into the database. This shift not only streamlined data retrieval through single SQL queries but also enhanced performance by exploiting SQL's advanced functionalities like Materialized Views, CTEs, and Window Functions. The initiative not only significantly reduced API response times but also minimized development and maintenance overhead, demonstrating the power of advanced SQL in backend optimization and the importance of embracing database capabilities for system efficiency.

講者

葉家郡

Jia-Jun Yeh, a seasoned principal software engineer specializing in FinTech, blends deep computer science knowledge with expertise in C++ and Go. He has evolved into a skilled Kubernetes administrator and application developer, demonstrating exceptional adaptability and swift learning. Over the past few years, Jia-Jun has confidently embraced a significant leadership role, steering his team towards innovation and collective achievement with decisive direction.

講者

Raiven Kao

一名專注於 Golang 的後端工程師，熱衷於探索與應用最新技術來提升開發效率和系統性能。擅長 Golang，撰寫了多篇技術文章，涵蓋隱式記憶體別名、樂觀鎖與悲觀鎖的應用以及 HTTP 路由改進等。在後端開發中經常使用 Kubernetes，也將許多服務跑在自架的 Homelab 中。在 Golang 和後端開發領域具備扎實技術能力和豐富項目經驗，期待在 COSCUP 2024 與更多開發者交流。

本文探討了一項名為 PGVector 的 PostgreSQL 擴充，其專為向量相似性搜索而設計。PGVector 的出現標誌著在 PostgreSQL 數據庫中實現向量相似性搜索的一個重要里程碑。通過 PGVector，用戶可以在 PostgreSQL 數據庫中儲存和查詢向量數據，從而實現更高效和準確的相似性搜索。本文將探討 PGVector 的設計原理、使用方法以及應用場景，並展望其在數據庫和相關領域中的潛在影響和價值。PGVector 的推出將為向量相似性搜索技術帶來新的發展機遇，並推動 PostgreSQL 數據庫在大數據和人工智慧應用中的更廣泛應用。

講者

里長伯

你的後端大小事,都是我的事！(能幫的上忙的話ＸＤ)

分享導入 PostgreSQL 開源資料庫的經驗和心得. 導入 PostgreSQL，導入的是資料庫？還是開源文化？

講者

古永忠

古永忠博士是資料庫系統研究員、社群貢獻者和資料工程師。從社群的角度傳遞產業資訊，並為企業提供開放的資料思維和技術。