PostgreSQL DBA
MinervaDB
PostgreSQL Internals
How to Safely Increase PostgreSQL’s Table Column Limit 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 errors during object creation and removal using the IF [NOT] EXISTS DDL clause in PostgreSQL
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
Index Wildcard in PostgreSQL
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
Simple steps for implementing optimal SQL programs in PostgreSQL
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
The InnoDB history list length increased significantly – What to do next?
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
Tuning UNDO Operations in MySQL
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
How can you reduce lock contention in MySQL?
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
What do we look for in a PostgreSQL execution plan?
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 […]