PostgreSQL DBA
MinervaDB Blog
PostgreSQL Internals
PostgreSQL Table Column Limit: Safely Increasing It Beyond 1664
If you’ve ever encountered the PostgreSQL column limit of 1,664 columns per table, you know it can be a real hurdle when designing wide tables. This limit is enforced by the internal MaxTupleAttributeNumber parameter. In […]
MinervaDB
Prevent Error PostgreSQL: Using IF [NOT] EXISTS for Object Creation and Removal
The IF [NOT] EXISTS DDL clause is a useful feature in PostgreSQL that can help prevent errors during object creation and removal. This clause allows database administrators to specify whether or not to create or […]
PostgreSQL Internals
PostgreSQL Index Wildcard Explained
Index wildcard is a technique used in PostgreSQL to create an index on a partial string in a column, rather than indexing the entire column. This technique can improve query performance when searching for data […]
MinervaDB
Optimal SQL PostgreSQL: Simple Steps for Implementing Optimal Programs
The SQL parser in PostgreSQL is implemented using a combination of lexical analysis, syntax analysis, semantic analysis, and code generation. The parser first converts the input SQL text into tokens, and then performs syntax and […]
PostgreSQL Performance
Troubleshooting PostgreSQL Query Performance
Monitoring query latency, wait events, and locks in PostgreSQL helps identify and diagnose performance bottlenecks. Here’s a guide on how to monitor these aspects: Here’s a sample query to gather information about locks, wait events, […]
MySQL Performance
InnoDB History Length: What to Do When It Increases Significantly
Introduction The InnoDB history list length can grow significantly if there are long-running transactions that generate a lot of undo logs or if there are frequent transactions with large amounts of data being modified. This […]
MySQL Performance
MySQL UNDO Operations: Tuning Guide
In MySQL, undo operations are used to provide transactional consistency and to allow for rolling back changes made to the database during a transaction. Undo operations are implemented in the InnoDB storage engine, which is […]
MySQL Performance
MySQL Lock Contention: How to Reduce It
Reducing lock contention in MySQL involves implementing various techniques and strategies that help minimize the occurrence of lock-related performance issues. Here are some of the ways to reduce lock contention in MySQL: By implementing these […]
PostgreSQL Performance
PostgreSQL Execution Plans: What to Look For
PostgreSQL execution plans PostgreSQL execution plans provide information on how the database intends to execute a given query. Understanding execution plans is crucial to identify performance issues and optimize query performance. Here are some of […]