Hints to optimise queries with a LIKE comparisonBy Federico Razzoli | September 15, 2022In SQL, using the LIKE operator is a powerful way to find strings that match a certain pattern. It's suitable for ...Read More
AlloyDB versus PostgreSQL: a performance reviewBy Michael Aboagye | July 19, 2022What is faster: PostgreSQL or AlloyDB? Some benchmarks and a performance analysis.Read More
Tuning PostgreSQL Auto-vacuumBy Michael Aboagye | April 28, 2022Why autovacuum is important in PostgreSQL and how to configure it properly.Read More
NULL comparisons in MariaDB, PostgreSQL, and SQLiteBy Federico Razzoli | September 6, 2021Comparisons are tricky when NULL values are involved. But some databases offer some special, handy syntax to solve the problem.Read More
Populating tables faster in PostgreSQLBy Michael Aboagye | July 9, 2021Fast-loading rows into a PostgreSQL table using the COPY FROM command.Read More
Tuning Linux kernel for PostgreSQLBy Michael Aboagye | June 19, 2021Learn how to tune Linux parameters to improve PostgreSQL performance and reliability.Read More
Row-level Security Policy in PostgreSQLBy Michael Aboagye | June 11, 2021Learn how to grant or revoke rows privileges in PostgreSQL.Read More
Basic practices for optimizing read and write performance in PostgreSQLBy Michael Aboagye | March 11, 2021Optimizing read and write performance varies for every Postgres database server in a different environment.Read More