Detect missing combined indexes (automatically)

From: Thomas Güttler <guettliml(at)thomas-guettler(dot)de>
To: PostgreSQL mailing lists <pgsql-performance(at)postgresql(dot)org>
Subject: Detect missing combined indexes (automatically)
Date: 2019-01-10 12:56:02
Message-ID: fdbf5d62-c06a-761e-276e-ef72e772ed25@thomas-guettler.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Is there a way to detect missing combined indexes automatically

I am managing a lot of databases and I think a lot of performance
could get gained.

But I don't want to do this manually.

My focus is on missing combined indexes, since for missing
single indexes there are already tools available.

Regards,
Thomas Güttler

--
Thomas Guettler http://www.thomas-guettler.de/
I am looking for feedback: https://github.com/guettli/programming-guidelines

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Guillaume Lelarge 2019-01-10 18:42:33 Re: does dml operations load the blocks to the shared buffers ?
Previous Message Amit Langote 2019-01-10 12:23:40 Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0