Explains how to display PostgreSQL timestamps with a specific timezone offset, including a custom function solution.
![[Video] Office Hours in Tokyo, Japan](https://alldevblogs.blob.core.windows.net/thumbs/article-14278cd3a80f-full-1eb1b061.webp)
Brent Ozar answers SQL Server, Azure SQL, and database management questions from viewers during an informal 'Office Hours' session in Tokyo.
Explores creative PostgreSQL optimization techniques beyond standard indexing and query rewriting, focusing on constraint exclusion and function-based indexes.
A developer recounts debugging a PostgreSQL container stability issue that turned out to be a hidden security vulnerability, sharing lessons learned.
A developer creates a simple, AI-assisted Node.js tool for automatically loading CSV files into PostgreSQL with minimal configuration.
Author details a fix for suboptimal indentation in complex SQL join conditions within the paste.depesz.com query pretty-printer.
A technical analysis measuring the performance impact of adding indexes on write operations (COPY) in PostgreSQL, showing slowdowns and size overhead.
PostgreSQL 19 introduces new ALTER TABLE commands to MERGE and SPLIT partitions, with initial single-process, locked implementations.
Analysis of a complex RCE attack chain in PostHog exploiting SSRF, a ClickHouse SQL 0day, and default PostgreSQL credentials.
A guide for new DBAs on managing PostgreSQL extensions, covering installation, version checking, and essential maintenance practices.
A technical analysis comparing PostgreSQL JSON storage options, compression methods (pglz vs. lz4), and performance optimizations.
A fun exploration of psql's scripting capabilities, testing if it's Turing complete by implementing a Fibonacci sequence calculator.
Compares PostgreSQL's pg_stat_wal metrics to Oracle's detailed redo logging instrumentation for database administrators.
Explains new PostgreSQL 19 features for synchronizing sequences via logical replication, including ALL SEQUENCES support and a sync worker.
Explores strategies for cleaning up test data in Spring/Hibernate applications, covering pitfalls like @Transactional and PostgreSQL performance tuning.
Analyzes the performance and storage trade-offs of using a dedicated tsvector column versus an expression index for full-text search in PostgreSQL.
PostgreSQL 19 adds a new %S prompt variable to psql to display the current search_path, aiding users who frequently work with multiple schemas.
PostgreSQL 19 adds direct COPY TO support for partitioned tables, improving usability and performance over the previous SELECT workaround.
A guide on integrating Asyncpg with FastAPI and Air for direct PostgreSQL database access, bypassing heavier ORMs like SQLAlchemy.
PostgreSQL 19 adds IGNORE NULLS/RESPECT NULLS options to window functions like LAG and FIRST_VALUE, improving data handling.
