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

Поиск
Список
Период
Сортировка
От Matheus de Oliveira
Тема Re: [EXTERNAL] Need help with performance tuning pg12 on linux
Дата
Msg-id CAJghg4KMddDoNSEpCkn1V6QzSAO1+D-76USb=ESu1PBQboUypA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [EXTERNAL] Need help with performance tuning pg12 on linux  (Ranier Vilela <ranier.vf@gmail.com>)
Список pgsql-performance
Дерево обсуждения

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 по дате отправления:

Предыдущее
От: Matheus de Oliveira
Дата:
Сообщение: Re: [EXTERNAL] Need help with performance tuning pg12 on linux
Следующее
От: mohini mane
Дата:
Сообщение: Re: Parallel hints in PostgreSQL with consistent perfromance