In SQL, using the LIKE operator is a powerful way to find strings that match a certain pattern. It's suitable for most use cases, thanks to its two jolly characters: _ means any one character. %...
PostgreSQL
AlloyDB versus PostgreSQL: a performance review
What is faster: PostgreSQL or AlloyDB? Some benchmarks and a performance analysis.
Tuning PostgreSQL Auto-vacuum
Why autovacuum is important in PostgreSQL and how to configure it properly.
NULL comparisons in MariaDB, PostgreSQL, and SQLite
Comparisons are tricky when NULL values are involved. But some databases offer some special, handy syntax to solve the problem.
Populating tables faster in PostgreSQL
Fast-loading rows into a PostgreSQL table using the COPY FROM command.
Tuning Linux kernel for PostgreSQL
Learn how to tune Linux parameters to improve PostgreSQL performance and reliability.
Row-level Security Policy in PostgreSQL
Learn how to grant or revoke rows privileges in PostgreSQL.
Basic practices for optimizing read and write performance in PostgreSQL
Optimizing read and write performance varies for every Postgres database server in a different environment.