When debugging slow SQL queries, it’s helpful to understand the database engine's query plan. Whenever you execute a...

This is a small example on how you can check if your Postgres index can be used by a specific query in you Rails application. For more complex execution plans...

...comfortable using the built-in options for key lengths or ordering. (excerpt from: Fancy Postgres indexes with ActiveRecord) So regarding to the cited site Rails 5+ allows me to use...

When creating an index using CREATE INDEX, Postgres will create a B-Tree type index by default. The B-Tree...

PostgreSQL has partial indexes. With a partial index you tell Postgres to only index rows matching a given query.

When changing glibc versions, it's possible to end up with corrupt indexes in PostgreSQL. Are My Indexes Affected?

When changing the glibc version, it's possible that the upgrade also includes changes to how locales work.

PostgreSQL, unlike MySQL, treats strings as case sensitive in all circumstances. This includes comparison with = and LIKE collision detection in...

For searching in large database tables we usually use PostgreSQL's fulltext search capabilities. While this works reasonably well for...

SQL in PostgreSQL: PostgreSQL supports many powerful extensions of the SQL standard PostgreSQL Indexes PostgreSQL Mathematical Operators Useful PostgreSQL commands PostgreSQL MVCC How does MVCC work?

Log-Shipping Standby Servers PostgreSQL VACUUM Investigating slow PostgreSQL Index Only scans Aufgaben Starte PostgreSQL mit einem Docker Container. Erstelle eine Datenbank mit dem Namen vacationplan

So you're switching to PostgreSQL from MySQL? Here is some help... General hints on PostgreSQL \? opens the command overview...

PostgreSQL can cosplay as a full-text search engine. It doesn't have the features or fidelity of ElasticSearch or...