Command Prompt

Still running Postgres 12 or 13? Totally valid. With PgLTS from Command Prompt, you can get full support for your EOL PostgreSQL with real patches, real experts, no pressure to upgrade. Enjoy up to 3 more years of breathing room with PgLTS. Learn more at commandprompt.com/products/pglts #Postgres

Audax Data Manager 1.6 is live🚀 ✨Highlights: - New ERD with cardinality markers, smart routing, snap-to-grid & image export - New psql-like DB console - Hotkey navigation between DB Explorer and other sections of the app One tool for many databases 👇 www.commandprompt.com/products/aud...

Why does AI need so much compute? Neural networks can scale quadratically as inputs grow, while context adds more work. In Better AI: Faster, Part 1, Reza Rassool introduces Kwaai’s “blink transform,” research intended to make that growth linear instead: youtu.be/NO1k2gaLbKo #AI

Q: "When should I tune commit timestamp buffers?" A: Rarely. Default (0) auto-sizes from shared_buffers. Only adjust for high-transaction workloads with track_commit_timestamp enabled + performance issues. Supports replication & auditing. #PostgreSQL

When you’ve grown up being told to push through, how do you ask for support? Justin Reock, @mayers.io, and @offgridwithjd.bsky.social share their experiences in “The End of the Universe 07", “How We Talk About Mental Health.” Watch: youtu.be/xkD745TLnkA

Today's the day! Our team is joining PostgresWorld's live Q&A on Security and Privacy Best Practices at 1pm ET for a conversation about protecting PostgreSQL databases and data. postgresconf.org/conferences/...

What runs slower in your app’s next version? Hunter O’Brien wants an easier way to test it against a PostgreSQL database snapshot. Watch more on this T3D Postgres Wishlist episode: youtu.be/KeR1f_KG3xA

AGLedger used Valkey for queues and load balancing alongside PostgreSQL. In Part 2 of "When Postgres Is Enough", Michael Cooper explains how pg-boss meant he no longer needed Valkey and what happened during a three-hour simulated agent workload: youtu.be/_rLZQJIqMAs #PostgreSQL

If NumPy already has the operation you need, Cython isn't the answer. But when custom numeric logic can't translate cleanly into a single vectorized call, Cython memoryviews bridge the performance gap. Session 4 compares a Python loop, Cython, and NumPy's clip at youtu.be/nvp_iMjwZus

The value of AI isn't measured by how much work you hand over to it. SysAdmin James Campbell shares why engineering judgment still matters. youtu.be/srFsNtoCLF4

AI saves you hours of work. What happens when those hours were someone else’s job? @offgridwithjd.bsky.social and PgDog creator Lev Kokotov agree on the usefulness of AI, but have different expectations for how people will adapt. Watch the full conversation: youtu.be/SCXK9fFNK3M

How are you handling security and privacy in PostgreSQL? Our team is joining PostgresWorld's next live Q&A on Security and Privacy Best Practices on October 20th at 1pm ET. postgresconf.org/conferences/...

Compiled Cython code degrades to standard Python speeds if the hot path remains tethered to the interpreter. Session 3 shows how the annotation report helps you find it before deciding what to optimize next. youtu.be/CIGB5RQ9CzE

Your data changes, but the score on screen stays the same until the next refresh. Brian Fehrle’s Postgres wishlist starts with real-time materialized views. He explore what makes that difficult, especially with aggregates. Watch the T3D conversation: youtu.be/KEuLpA8meRA

Do you ever overlook the things that help the most? Amanda Nystrom and @offgridwithjd.bsky.social wrap up their stress management series by exploring why sleep, movement, boundaries and connection remain some of the most powerful tools we have. Listen to the full conversation: youtu.be/IZJMq2B-NBc

Getting a Cython module to compile is only part of the job. Session 2 looks at the build process and why the types inside the code still determine whether you get a real performance gain. youtu.be/t18_P6F-vqU

How much more information should Postgres logical replication provide? James Nelson, Founder and CTO of @pgcache.bsky.social, wants more visibility into schema changes. He and @offgridwithjd.bsky.social explore the trade-offs in T3D Postgres Wishlist. youtu.be/YC5B1zjFaZ0

Do you ever feel like you're being measured all the time? Amanda Nystrom and @offgridwithjd.bsky.social explore perfectionism, comparison, burnout, and the growing pressure to always get it right. Listen to the full conversation: youtu.be/QBJ9gHSeecQ

Working with JSONB in plPHP? The optional jsonb_plphp transform maps function arguments to native PHP values. Each function must declare TRANSFORM FOR TYPE jsonb. Read the docs: github.com/commandpromp... plPH: github.com/commandpromp...

AGLedger needed to run without phoning home. Michael Cooper began reviewing the stack, with Drizzle the first component removed. Our new three-part T3D series, "When Postgres Is Enough", starts here. Watch Part 1: youtu.be/uZiE1dD6Ae8 #PostgreSQL

Can your team merge more pull requests without spending a larger share of its time on new features? The End of the Universe EP06 (with @offgridwithjd.bsky.social, @mayers.io and Justin Reock) examines what AI productivity gains actually deliver. Watch: youtu.be/pfIzr0OvvdA #AI

How has AI changed what your team works on? If AI helps your team merge more pull requests in a shorter time frame, what else are they accomplishing? New features? Bug fixes?

The algorithm does not always need to change to make a Python loop faster. Session 1 shows what Cython can remove once the types are known at compile time. youtu.be/skHoiIob4qE

Write PostgreSQL procedures in your favorite language—even COBOL! plX transpiles your code directly to PL/pgSQL for safe, native, and fast procedures. Read how plX works: github.com/commandpromp...

Cloud database costs spike when PostgreSQL settings conflict with kernel caching. Greg Dostatni’s cost-aware tuning model demonstrates how proper memory allocation eliminates cache duplication, reducing disk IOPS up to 6x & lowering metered cloud storage tiers. www.commandprompt.com/blog/postgre...

A Patroni cluster upgrading to PostgreSQL 18 will trigger split-brain states if the Etcd lease TTL isn't adjusted to tolerate longer pg_upgrade disk syncs. Learn more at Group Swim today at 2pm ET. Register: postgresconf.org/conferences/...

Some of AI's biggest wins happen before code reaches production. Brian Fehrle shares why AI works best when it helps engineers review, debug, and strengthen their work. youtu.be/srFsNtoCLF4

Q: "Why are my log times confusing?" A: log_timezone sets the timezone for server logs (not data storage). Best practice: Use UTC for distributed teams. Use local only for single-location ops. Consistent logs = easier event correlation. #PostgreSQL

Which query plans did PostgreSQL consider but reject? Greg Dostatni wants a plan explorer that would show those alternatives and their estimated costs. Hear his case in T3D Sessions' Postgres Wishlist: youtu.be/bNeRc8Vm3NA #PostgreSQL

Why is it so easy to overlook everything that went right and focus on the part that didn’t? Amanda Nystrom and @offgridwithjd.bsky.social explore the science behind the pursuit of perfection and how it can shape stress, self-worth, and success. Listen to the full episode: youtu.be/2jF-ah1ZFjw

Would you accept an AI-generated pull request the contributor hasn't tested? Turso CEO Glauber Costa expects contributors to understand and test their code, even when AI writes it. Hear his conversation with JD on MTAR EP60: youtu.be/WA60GRxVpU4 #OpenSource

Your GIN index on JSONB isn't just slow; it bloats WAL files when matching on a non-indexed key. Join PostgresWorld's New Features Group Swim on September 16 at 2pm ET to learn about major features to resolve upgrade pains. Register: postgresconf.org/conferences/...

Clinical-trial team goal: every report under 1 min. One QC report took 9+ min. A query rewrite brought it to ~30 sec. For more of the story: www.commandprompt.com/about/case-s...

pgcolumnar 1.0-alpha2 offers read-only Iceberg access through foreign tables. Supported filters can skip files before opening them; EXPLAIN (ANALYZE) reports Files Pruned. Read the release notes: www.commandprompt.com/blog/pgcolum...

Python loops stall at the CPU level due to dynamic object overhead, slowing down execution as an algorithm scales. Our Mini Cython Series on YouTube shows how compiling and benchmarking bypasses these performance bottlenecks to optimize execution. www.youtube.com/playlist?lis...

Audax Data Manager 1.5 is live. Highlights: Oracle now supported in Schema Editor Spreadsheet-style copy/paste in Data Editor Full keyboard navigation in Database Explorer One tool for many databases. Get: github.com/commandpromp... Info: www.commandprompt.com/products/aud...

PostgreSQL gets a lot right. But what happens when fixing an edge case adds even more complexity? Ildefonso Camargo on LDAP authentication and large objects outside logical replication. youtu.be/YMcW7iWgYQ8

AI can make average work easier to produce. That makes your judgment, experience, and perspective more important. Nikki Barua talks about identifying what you uniquely bring to the work, then using AI to build from it. youtu.be/nLdoHk68tjo

For a regulated employer-benefits TPA client, an urgent issue led to a broader review of auditability, autovacuum, CDC, reporting, monitoring, and DR readiness. Keep your database stable and compliant: www.commandprompt.com/contact-us/

Part 2 of Beyond the 25% Rule looks at huge_pages. Greg Dostatni repeated the Part 1 benchmarks with 2 MiB and 1 GiB pages. Throughput changed little, but page-table memory use dropped substantially. www.commandprompt.com/blog/when-to...

AI doesn't replace engineering judgment. DBA Brian Fehrle shares why keeping humans in the decision loop still matters when AI becomes part of your workflow. youtu.be/srFsNtoCLF4

Python code can be correct and still be too slow for the job. Our Mini Cython Series is now on YouTube, with practical sessions on reducing Python overhead and using Cython where performance matters. www.youtube.com/playlist?lis...

We’re starting a new three-part series on PostgreSQL shared_buffers behavior in large-memory systems. In Part 1, Greg Dostatni tests the usual 25% guidance on a 128 GB system across point-update and analytics workloads. The results did not tell the same story. www.commandprompt.com/blog/postgre...

What changes when AI applications start working with images, video, and audio instead of just text? Marcel Kornacker explains why those workloads require rethinking the role of the database. Watch the full T3D Session: youtu.be/-8kS1WYVctM

Command Prompt provides PostgreSQL consulting and hands-on engineering for production environments. We start with the system your team actually runs and look beyond the database when the work requires it. www.commandprompt.com/contact-us/

Could a PostgreSQL major upgrade be as simple as install, restart, and continue? In this Postgres Wishlist episode, James and JD look at pg_upgrade, in-place upgrades, and replication across major versions. youtu.be/cKCGPJwXzS4 #PostgreSQL

Audax Data Manager Community Edition 1.5 is now available. Whether you're already using or trying Audax Data Manager for the first time, download the latest version and explore what's new in Community Edition 1.5. Follow and star the project: www.commandprompt.com/products/aud...

Do you ever feel mentally exhausted by things that technically were supposed to make life easier? Amanda and JD Drake talk about clutter, upgrades, subscriptions, distractions, consumerism, and the hidden stress of constantly managing more. Watch it now: youtu.be/pPSsnL8MqjU

People still hear "free" and assume compromises. That's exactly the myth Brian challenges in this Postgres Love Letter. The conversation isn't really about cost. It's about why PostgreSQL earned its reputation on quality long before people started talking about savings: youtu.be/NBFaLHRSElk

Everyone assumes AI needs bigger data centers. Reza Rassool makes the case for a different approach: distributed AI powered by the computing resources we already own. A thoughtful conversation about infrastructure, privacy, and where AI goes next. Watch here: youtu.be/H79xbDJ3_uE

plx is a PostgreSQL extension that lets you write stored functions and triggers in the dialect you already know (the current set is listed below). When you run CREATE FUNCTION, plx transpiles the body to plpgsql and stores that plpgsql in pg_proc.prosrc. github.com/commandpromp...