Re: dexter on AWS RDS auto tune queries

From: Christophe Pettus <xof(at)thebuild(dot)com>
To: Ayub Khan <ayub(dot)hp(at)gmail(dot)com>
Cc: Pgsql Performance <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: Re: dexter on AWS RDS auto tune queries
Date: 2021-06-07 05:00:46
Message-ID: 793E148F-0E4B-4945-8C99-BAC33390FB9B@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> On Jun 6, 2021, at 21:51, Ayub Khan <ayub(dot)hp(at)gmail(dot)com> wrote:
> Other than Dexter, Is there an auto tune or query performance indicator for postgres ?

Generally, auto-creating indexes isn't a great idea. I respect the work that went into Dexter, but it's much better to find the queries and study them, then decide if index creation is the right thing.

RDS has Performance Insights, which is a very useful tool for finding where the load on your server is actually coming from.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Ayub Khan 2021-06-07 07:49:52 Re: dexter on AWS RDS auto tune queries
Previous Message Julien Rouhaud 2021-06-07 04:57:37 Re: dexter on AWS RDS auto tune queries