Postgres Pro
Downloads
Home   >   mailing lists

Re: [EXTERNAL] Need help with performance tuning pg12 on linux - Mailing list pgsql-performance

From Matheus de Oliveira
Subject Re: [EXTERNAL] Need help with performance tuning pg12 on linux
Date
Msg-id CAJghg4KMddDoNSEpCkn1V6QzSAO1+D-76USb=ESu1PBQboUypA@mail.gmail.com
Whole thread Raw
In response to Re: [EXTERNAL] Need help with performance tuning pg12 on linux  (Ranier Vilela <ranier.vf@gmail.com>)
List pgsql-performance
Tree view

On Wed, Dec 27, 2023 at 2:23 PM Ranier Vilela <ranier.vf@gmail.com> wrote:
...

Although granule_file has an index as a foreign key, it seems to me that it is not being considered.

You seem to be mistaken here, a foreign key does not automatically create an index on the columns, you need to do it by yourself you really want that.

Best regards,
--
Matheus de Oliveira


pgsql-performance by date:

Previous
From: Matheus de Oliveira
Date:
Subject: Re: [EXTERNAL] Need help with performance tuning pg12 on linux
Next
From: mohini mane
Date:
Subject: Re: Parallel hints in PostgreSQL with consistent perfromance