Re: [EXTERNAL] Need help with performance tuning pg12 on linux

From: Matheus de Oliveira <matioli(dot)matheus(at)gmail(dot)com>
To: Ranier Vilela <ranier(dot)vf(at)gmail(dot)com>
Cc: "Wilson, Maria Louise (LARC-E301)[RSES]" <m(dot)l(dot)wilson(at)nasa(dot)gov>, Frits Hoogland <frits(dot)hoogland(at)gmail(dot)com>, "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: Re: [EXTERNAL] Need help with performance tuning pg12 on linux
Date: 2023-12-27 18:06:45
Message-ID: CAJghg4KMddDoNSEpCkn1V6QzSAO1+D-76USb=ESu1PBQboUypA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, Dec 27, 2023 at 2:23 PM Ranier Vilela <ranier(dot)vf(at)gmail(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message mohini mane 2023-12-28 12:46:59 Re: Parallel hints in PostgreSQL with consistent perfromance
Previous Message Matheus de Oliveira 2023-12-27 18:05:26 Re: [EXTERNAL] Need help with performance tuning pg12 on linux