> On Jun 6, 2021, at 21:51, Ayub Khan 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, the
Hi,
On Mon, Jun 7, 2021 at 12:52 PM Ayub Khan wrote:
>
> Other than Dexter, Is there an auto tune or query performance indicator for
> postgres ?
It depends. If you're on AWS or any other cloud, probably nothing
apart from tools based on logs or standard SQL execution (so nothing
based on thir
Other than Dexter, Is there an auto tune or query performance indicator for
postgres ?
Also which are the most commonly used monitoring (slow query, cpu, index
creation for missing indexs ) tools being used for postgres ?
--Ayub
On 2021-05-29 13:35, Andrew Dunstan wrote:
On 5/29/21 3:59 PM, Dean Gibson (DB Administrator) wrote:
Meanwhile, I've been doing some checking. If I remove "CAST(
license_status AS CHAR ) = 'A'", the problem disappears. Changing the
JOIN to a RIGHT JOIN, & replacing WHERE with ON, also "solves"
