How to Find and Fix PostgreSQL Blocking Sessions Using Built-In Tools

·1 views

PostgreSQL production environments can slow down significantly when sessions become blocked, often due to connections stuck in an 'idle in transaction' state where a transaction was opened but never committed or rolled back. These lingering sessions can hold locks, prevent other queries from completing, and stop VACUUM from cleaning up dead rows. Administrators can investigate such issues using the pg_stat_activity view, which reveals session states, query durations, and application names. PostgreSQL provides three key functions — pg_cancel_backend(), pg_terminate_backend(), and pg_blocking_pids() — to identify and terminate problem sessions. Beyond simply killing a blocking session, the recommended approach is to understand the root cause and implement safeguards, such as setting application_name per service, to prevent recurrence.

Read the full story at DEV Community

This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)

Tutorial: How to Build a Safe Prompt Release Service for AI Voice Companions

A developer tutorial published on DEV Community outlines the risks of uncontrolled prompt editing in AI-powered voice companions, where mid-session changes can cause consecutive conversation turns to follow different instructions. The guide argues that release discipline — not just fast iteration — is the critical engineering skill when working with AI prompts. Using TypeScript and Node.js 20, the tutorial walks through building a local prompt-release service designed for Tencent RTC's Conversational AI platform. The service enforces a structured prompt lifecycle, requiring automated checks and human approval before any prompt version becomes active. It also pins each conversation session to a single prompt version and separates model-controlled behavior from deterministic application-level controls such as safety, mute, and stop functions.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Six AgentGPT Alternatives for Real Autonomous Work in 2026

AgentGPT, built by Reworkd, is widely used as a browser-based AI agent demo that breaks down goals into tasks and streams its reasoning live, but it lacks the integrations, guardrails, and scheduling needed for real-world work. A 2026 roundup identifies six alternatives grouped into three categories: developer frameworks, research agents, and deployable agents for teams or clients. Tools like CrewAI and Microsoft Agent Framework serve engineers building multi-agent systems, while Manus and Genspark handle open-ended research tasks. Platforms such as aramb and Dust focus on letting users deploy agents that others can access via a shared link without exposing credentials or configuration. The guide emphasizes that most users who find AgentGPT limiting actually need app integrations, spend controls, and repeatable scheduling rather than another sandbox demo.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

PHP Internals Debates AI-Authored Messages and New array_str_contain() RFC

During the week of August 26, 2026, the PHP internals mailing list saw debate over messages suspected to be written or heavily assisted by AI, with 24 follow-up messages discussing where the line between translation assistance and AI-generated authorship should be drawn. Community members acknowledged that non-native English speakers have legitimate accessibility needs, but objected to AI generating the arguments themselves, with no formal policy yet established. Separately, contributor Sepehr Mahmoudi proposed a new array_match() function to filter arrays by substring in C for performance, which was later renamed array_str_contain() and retargeted at PHP 8.7 after PHP 8.6 was frozen. Multiple developers pushed back, arguing that existing tools like array_filter(), partial function application in 8.6, and preg_grep() already cover the use case adequately. A documentation-related pull request was also raised by Nick Sdot, proposing a mechanical conversion of PHP's internals book from reStructuredText to Markdown.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

AdvantageBuilder Demo Combines JavaScript, PowerShell and Local AI to Generate Fairy Tales

A developer has published a demo showcasing AdvantageBuilder, a multi-runtime automation platform that orchestrates JavaScript V8, PowerShell, .NET, and a locally running Ollama AI model. The workflow uses a JavaScript macro to call a PowerShell helper, which sends a prompt to Ollama's local REST API and retrieves a generated fairy tale of under 200 words. A second PowerShell helper then uses .NET's System.Speech library to narrate the story aloud via a selected desktop voice. AdvantageBuilder handles argument passing, runtime switching, and JSON serialization automatically, allowing different runtimes to communicate within a single macro. The developer positions this setup as a practical starting point for building local AI applications — such as voice assistants or desktop automation tools — without relying on cloud services.

0 comments Read more at DEV Community