Learnings

Boost your knowledge with the insights from our expert team.

<p>Order of columns in a compound index in PostgreSQL (and query order): </p>

Flávio Juvenal

Dec 14, 2017

Topics:

db, postgres

<p>Will UUID as primary key in PostgreSQL give bad index performance? </p>

Flávio Juvenal

Dec 14, 2017

Topics:

postgres, uuid

<p>Understanding time format of the EXPLAIN command in Postgres </p>

Flávio Juvenal

Dec 13, 2017

Topics:

performance, postgres

<p>Show size of various PostgreSQL objects like indexes, materialized views, tables, etc: </p>

Flávio Juvenal

Nov 23, 2017

Topics:

postgres

<p>Reading a Postgres EXPLAIN ANALYZE Query Plan: </p>

Flávio Juvenal

Nov 22, 2017

Topics:

db, performance, postgres

<p>Use django-postgres-extra for native upserts, more powerful HStoreField, more signals and indexes with conditions: </p>

Flávio Juvenal

Nov 16, 2017

Topics:

django, postgres

<p>Show database, table and indexes size in Postgres: </p>

Flávio Juvenal

Nov 3, 2017

Topics:

database, postgres

<p>Postgres SQL Views in Django: </p>

Flávio Juvenal

Nov 2, 2017

Topics:

django, postgres

<p>Implementing faceted search with Django and PostgreSQL: </p>

Flávio Juvenal

Oct 23, 2017

Topics:

django, postgres, search

<p>Easily make Django connect to Postgres using SSL </p>

Carlos Coelho

May 17, 2017

Topics:

django, postgres, ssl

<p>Add Postgres full-text searching to your Django application </p>

Carlos Coelho

May 11, 2017

Topics:

django, postgres

<p>Postgres full-text search is Good Enough! </p>

Flávio Juvenal

Apr 27, 2017

Topics:

db, postgres, search, sql