#postgreSQL

@bayareapostgres.bsky.social

52 minutes ago

"Databases in the Agent Era" with Monica Sarbu, Tue, Apr 14, 2026, 12:00 PM | Meetup Join us virtually on Tuesday, April 14th for "Databases in the Agent Era" with Monica Sarbu. We are entering a new era where AI agents are first-class users of data infras

Join us on Tuesday, April 14th at Noon PDT for "Databases in the Agent Era" with Monica Sarbu! That's just 5 days away! RSVP today!

www.meetup.com/postgresql-1...

@PostgreSQL #PostgreSQL #postgres #meetup

PostgreSQL

@postgresql.activitypub.awakari.com.ap.brid.gy

52 minutes ago

Странное тестовое задание или как упустить работу мечты Из названия не понятно буду ли я писать про странно...

#очереди #оптимизация #запросов #sql #postgresql

Origin | Interest | Match

PgDay Boston

@pgdayboston.bsky.social

1 hour ago

PgDay Boston 2026 A 1-day PostgreSQL community conference in Boston, US.

PgDay Boston is shaping up to be a great conference. But who are we? What are we all about? Click the link below to find out!

2026.pgdayboston.org/about/

@PostgreSQL #PostgreSQL #postgres

EDB

@edbpostgres.bsky.social

1 hour ago

Postgres Conference: 2026 ### Energizing People with Data and Creativity With a track record of providing growth and opportunity, education and connections since 2007, Postgres Conference presents a truly positive experience…

At the Postgres Conference 2026 in San Jose, EDB Danish Khan & Neel Patel will give a workshop on running #PostgreSQL in #Kubernetes with #CloudNativePG, and Yogesh Jain will give a talk about "Building Real-Time, Data-Aware Intelligence with Postgres & MCP": postgresconf.org/conferences/...

さるぼっと@IT最新動向を配信

@sarubot.bsky.social

1 hour ago

トヨタの生産管理から大規模ゲームの負荷分散まで、PostgreSQLは信頼性の代名詞です。pgpool-IIとの組合せにより、OSSでも商用DB並みの可用性と拡張性を実現可能。

・トヨタ：生産管理の中核
・メガゲーム：100万規模の負荷分散

#PostgreSQL #DBエンジニア
https://t.co/E4B8f9lQ43

Android

@android.activitypub.awakari.com.ap.brid.gy

1 hour ago

Приложение полностью написанное AI У меня возникла идея провести эксперимент, чтобы лучше понять текущие во...

#ai #tailwind #angular #nestjs #postgresql #mobile #development

Origin | Interest | Match

PGX

@pgexperts.bsky.social

2 hours ago

Our Community Engagement | PGX: The PostgreSQL Experts™ PGX is an independent PostgreSQL consultancy, providing 24x7 support and consulting for installations of all sizes.

PGX is proud of our commitment to the PostgreSQL Community. That's why we encourage each of our employees to volunteer for PgUS and its affiliated conferences and User Groups.

pgexperts.com/corporate/co...

#PostgreSQL #postgres

@qdrddr.bsky.social

2 hours ago

Install Wren AI as a #CLI tool (no containers) and query your DB from terminal or with UI! Has build-in @duckdb.org , supports #PostgreSQL, #BigQuery, #Snowflake, #MySQL #MariaDB, #Oracle DB, #Microsoft #SQL, Clickhouse, etc. #Python #DataBase #AI #LLM #Agents #RAG

#OpenSource AGPL 3.0 lic

United States PostgreSQL Association

@pgus.bsky.social

3 hours ago

PgUS - Community Development The mission of the Community Development Committee of the United States PostgreSQL Association is to develop participation in the PostgreSQL community through outreach programs and the support of…

The PgUS Community Development Committee is working hard to ensure that our community is safe and welcoming to everyone! Click the link below for more info!

postgresql.us/community_de...

#PostgreSQL #postgres

@pg-data.bsky.social

3 hours ago

We are pleased to welcome Redgate as a Platinum Sponsor ⭐

Thank you for supporting PG Data 2026 and our community 🤝
Learn more: www.red-gate.com

#PGData #PGData2026 #PostgreSQL 🐘 #TechCommunity #DataEngineering #OpenSource #Sponsorship #AWS

PgDay Boston

@pgdayboston.bsky.social

5 hours ago

PgDay Boston 2026 Sponsors We are proud to be associated with these fine sponsors, without whom PgDay Boston 2026 would not be possible!

We think your company’s logo would look great on our sponsor page! Check out the sponsorship opportunities and let them know today!

2026.pgdayboston.org/sponsors/

#PostgreSQL #postgres #conference

EDB

@edbpostgres.bsky.social

6 hours ago

PGDay Armenia 2026 April 30, 2026Armenia Marriott Hotel Yerevan

PGDay Armenia is taking place April 30, in Yerevan. Floor Drees and Boriss Mejias volunteered on the Talk Selection Committee, Bruce Momjian and Xavier Fischer secured sessions. They'll be talking about #PostgreSQL as an MCP Server, and the PostgreSQL Frontend/Backend Protocol: pgdayarmenia.com

CloudNativePG

@cloudnativepg.bsky.social

7 hours ago

Project Lightning Talk: Five Minutes by CloudNativePG River - Gabriele Quaresima, Contributor Don't miss out! Join us at our next KubeCon + CloudNativeCon events in Mumbai, India (18-19 June, 2026), Yokohama, Japan (29-30 July, 2026), and Shanghai, China (8-9 September, 2026). Connect with…

Gabriele Quaresima's lightning talk at #KubeCon is live for your viewing pleasure. Spend 5 minutes by the CloudNativePG river with us: www.youtube.com/watch?v=Cwz7... #PostgreSQL #Kubernetes #DoK

PostgreSQL

@postgresql.activitypub.awakari.com.ap.brid.gy

9 hours ago

RANK() vs DENSE_RANK(): ошибка, которая ломает топ-N в проде При работе с данными в SQL рано или поздно возникает задача р...

#sql #rank #dense_rank #window #functions #postgresql #оптимизация #производительность #аналитика #базы #данных

Origin | Interest | Match

PostgreSQL

@postgresql.activitypub.awakari.com.ap.brid.gy

10 hours ago

Kernel et son historique git : stats, commits annulés 3x, les plus buggés, le 1er Janvier ou à Noël, contributeurs uniques etc https://oseifert.ch/blog/linux-kernel-pgit Commentaires : voir le...

#historique #postgresql #golang #kernel #git

Origin | Interest | Match

PostgreSQL

@postgresql.activitypub.awakari.com.ap.brid.gy

10 hours ago

Kernel et son historique git : stats, commits annulés 3x, les plus buggés, le 1er Janvier ou à Noël, contributeurs uniques etc https://oseifert.ch/blog/linux-kernel-pgit Commentaires : voir le...

#git #historique #postgresql #golang #kernel

Origin | Interest | Match

PostgreSQL

@postgresql.activitypub.awakari.com.ap.brid.gy

10 hours ago

Kernel et son historique git : stats, commits annulés 3x, les plus buggés, le 1er Janvier ou à Noël, contributeurs uniques etc https://oseifert.ch/blog/linux-kernel-pgit Commentaires : voir le...

#kernel #git #historique #postgresql #golang

Origin | Interest | Match

PostgreSQL

@postgresql.activitypub.awakari.com.ap.brid.gy

10 hours ago

Kernel et son historique git : stats, commits annulés 3x, les plus buggés, le 1er Janvier ou à Noël, contributeurs uniques etc https://oseifert.ch/blog/linux-kernel-pgit Commentaires : voir le...

#postgresql #golang #kernel #git #historique

Origin | Interest | Match

Micha the DevOp

@michabbb.bsky.social

20 hours ago

🏗️ Versioning through DB schemas:

Instead of managing API versions in code, PostgREST uses #PostgreSQL schemas. Tables can change, the public API stays stable behind views. Clean separation, no brittle endpoints.

Micha the DevOp

@michabbb.bsky.social

20 hours ago

🐘 PostgREST turns your #PostgreSQL #database into a fully #RESTful #API — instantly. No backend code needed 🚀

🧵👇 #PostgreSQL #REST #OpenSource #DevTools

Percona

@percona.bsky.social

21 hours ago

"PostgreSQL doesn't need Redis anymore."

In our next Open Source Unplugged session, Percona tech leads Martin Visser (Valkey) and Jobin Augustine (PostgreSQL) tackle the caching question head-on.

#OpenSource #PostgreSQL #Percona

Event Registration:
https://bit.ly/4e792rz

PostgreSQL

@postgresql.activitypub.awakari.com.ap.brid.gy

22 hours ago

[Launched] Generally Available: Enhancements to maintenance notifications in Azure Service Health We’re introducing regional level consolidated maintenance notifications for Azure Database for Po...

#Azure #Updates #Azure #Database #for #PostgreSQL #Databases #Features #Hybrid #+ #Multicloud […]

United States PostgreSQL Association

@pgus.bsky.social

1 day ago

Migrating from Oracle to PostgreSQL: Strategy, Tools, and Best Practices, Wed, Apr 15, 2026, 12:00 PM | Meetup Migrating from Oracle to PostgreSQL has become a key modernization strategy for organizations seeking cost optimization, open-source flexibility, and cloud readiness. Howev

The next Postgres for All is a week from today! Join us online for “Migrating from Oracle to PostgreSQL: Strategy, Tools, and Best Practices” with Y V Ravi Kumar, Phani Kadambari and Arun Kumar Samayam!

www.meetup.com/postgres-mee...

#PostgreSQL #postgres

PgDay Boston

@pgdayboston.bsky.social

1 day ago

Registration – PgDay Boston 2026 Register now for PgDay Boston 2026!

Early Bird registration for PgDay Boston is open until April 17th! Register today and get a nice discount!

2026.pgdayboston.org/registration/

#PostgreSQL #postgres #conference

Rad Web Hosting

@radwebhosting.com

1 day ago

How to Install and Run ArchiveBox on Ubuntu VPS Server in 5 Minutes (Quick Start Guide)

How to Install and Run ArchiveBox on Ubuntu VPS Server in 5 Minutes (Quick Start Guide)
#archivebox #installguide #nodejs #npm #opensource #postgresql #python #selfhosted #selfhosting #ubuntu #vps #vpsguide #Cloud #Guides #VPS

PGX

@pgexperts.bsky.social

1 day ago

PGConf.dev 2026 PGConf.dev 2026 will be held on May 19–22 in Vancouver, BC to bring users, developers, and organizers together to advance PostgreSQL development.

Stacey Haysler will be adding her perspective as a community organizer to the panel “Beyond the Source: The Human Architecture of PostgreSQL” at PGConf.dev! We hope you’ll join us on Tuesday, May 19th!

2026.pgconf.dev/session/558

#PostgreSQL #postgres #conference

Postgres Summit US

@pgsummitus.bsky.social

1 day ago

Volunteer Introduction Thank you for your interest in volunteering with PgUS! Please complete the requested fields, and we'll be in touch soon! For Committee roles, please note the following: *Each Committee meets once per…

Interested in volunteering for PG Summit US? We have multiple volunteer opportunities available. Fill out the form below and we’ll be in touch!

bit.ly/pgusvolunteer

@PostgreSQL #PostgreSQL #postgres

United States PostgreSQL Association

@pgus.bsky.social

1 day ago

PgUS - Become a Member The United States PostgreSQL Association affectionately known as PgUS is a IRS 501(c)(3) public charity. Our purpose is to support the growth and education about the world's most advanced open source…

Your membership with PgUS allows you to vote in elections, run for the Board, and help shape the future of our community! Join today!

postgresql.us/becomeamember/

#PostgreSQL #postgres

PgDay Boston

@pgdayboston.bsky.social

1 day ago

PgDay Boston 2026 A 1-day PostgreSQL community conference in Boston, US.

PgDay Boston will be held at the Museum of Science! We think this will be a fantastic setting for a conference and we hope you’ll agree!

2026.pgdayboston.org/venue/

#PostgreSQL #postgres #conference

PostgreSQL

@postgresql.activitypub.awakari.com.ap.brid.gy

1 day ago

In the world of PostgreSQL performance tuning, **`work_mem`** is one of the most frequently misunderstood parameters. Many administrators assume it represents a total memory limit for a database session or a single query, but in reality, its impact is much more granular and potentially explosive. Understanding how this setting scales with complex SQL statements is the key to balancing high-speed execution with system stability. * * * Table of Contents Toggle * What is work_mem? * The Hidden Multiplier: Multiple Operations * Amplification through Parallelism * Practical Examples of Memory Consumption * How to Audit and Adjust * Summary Table: Memory Limits by Operation #### **What is`work_mem`?** The **`work_mem`** parameter sets the **base maximum amount of memory** that an individual query operation—such as a sort or a hash table—can consume before PostgreSQL is forced to write data to **temporary disk files**. While writing to disk (often called “spilling”) prevents the system from crashing due to memory exhaustion, it is significantly slower than processing data in RAM. #### **The Hidden Multiplier: Multiple Operations** The most critical takeaway is that `work_mem` is **not a per-query limit**. A single complex query often involves multiple operations simultaneously, such as several joins and a final sort. Each of these nodes in the execution plan is allowed to use the full `work_mem` allocation. Consequently, a single connection could easily consume **many times** the value of `work_mem` at its peak. #### **Amplification through Parallelism** When PostgreSQL utilizes **parallel query** , the memory demand scales even further. Resource limits like `work_mem` are applied **individually to each worker process**. For example, a query using four background workers and one leader process could theoretically utilize **five times** the memory of a serial query, as each process manages its own set of sorts and hashes. * * * #### **Practical Examples of Memory Consumption** **Example 1: The Multi-Join and Sort Scenario** Consider a query that joins three large tables and sorts the final result: SELECT * FROM orders o JOIN customers c ON o.customer_id = c.id JOIN products p ON o.product_id = p.id ORDER BY o.order_date; If the execution plan for this query uses two **Hash Joins** and one **Sort** node, and `work_mem` is set to 64MB: * **Hash Join 1:** Up to 128MB (64MB * `hash_mem_multiplier` of 2.0). * **Hash Join 2:** Up to 128MB. * **Sort Node:** Up to 64MB. * **Total Peak RAM:** This single query could consume **320MB** of local memory. **Example 2: Parallel Query Impact** If you run a heavy aggregation on a partitioned table using four parallel workers: SELECT category, SUM(sales) FROM large_sales_table GROUP BY category; If this plan involves a **Parallel Hash Aggregate** , every worker process and the leader can allocate their own memory for the hash table. If `work_mem` is 100MB, the system might allocate roughly **500MB** (1 leader + 4 workers) to satisfy this single statement. * * * #### **How to Audit and Adjust** To determine if your `work_mem` is set correctly, you should use **`EXPLAIN ANALYZE`** on your most complex queries. 1. **Check for Disk Spilling:** Look for the phrase **“External sort Disk”** or **“Batches”** in the output. If these appear, the operation exceeded your `work_mem` and was forced to use slow disk I/O. 2. **Verify Memory Usage:** The sort node will explicitly state the **Memory used** (e.g., “Memory: 74kB”) if the operation completed entirely in RAM. 3. **Real-Time Diagnostics:** If a connection seems to be hogging RAM, you can use the function **`pg_log_backend_memory_contexts(PID)`** to dump a detailed breakdown of that process’s memory usage into the PostgreSQL server logs. #### **Summary Table: Memory Limits by Operation** Operation Type| Memory Limit Formula| Key Configuration ---|---|--- **Standard Sort** (`ORDER BY`, `DISTINCT`)| `work_mem`| **Hash-based** (Hash Join, Hash Agg)| `work_mem * hash_mem_multiplier`| **Parallel Query**| `(Workers + 1) * Operation Limit`| **Maintenance** (`CREATE INDEX`, `VACUUM`)| `maintenance_work_mem`| **Final Recommendation:** Be conservative with the global `work_mem` setting to avoid the Linux **OOM (Out of Memory) Killer**. If specific reporting queries require more RAM, it is safer to increase the limit for just that session using **`SET work_mem = '256MB';`** rather than changing it for the entire cluster. See also: Mastering the Linux Command Line — Your Complete Free Training Guide

The Multiplier Effect: Mastering PostgreSQL’s work_mem for Complex Queries In the world of PostgreSQL performance tuning, work_mem is one of the most frequently misunderstood parameters. Many adm...

#Postgresql

Origin | Interest | Match