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

Поиск
Список
Период
Сортировка
От Ranier Vilela
Тема Re: [EXTERNAL] Need help with performance tuning pg12 on linux
Дата
Msg-id CAEudQAqf5sUumKEP0WmDPBHP8X1qnZEzmKum3z=-HaTg5z=7vg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [EXTERNAL] Need help with performance tuning pg12 on linux  ("Wilson, Maria Louise (LARC-E301)[RSES]" <m.l.wilson@nasa.gov>)
Ответы Re: [EXTERNAL] Need help with performance tuning pg12 on linux  ("Wilson, Maria Louise (LARC-E301)[RSES]" <m.l.wilson@nasa.gov>)
Re: [EXTERNAL] Need help with performance tuning pg12 on linux  (Matheus de Oliveira <matioli.matheus@gmail.com>)
Список pgsql-performance
Дерево обсуждения
Em qua., 27 de dez. de 2023 às 14:11, Wilson, Maria Louise (LARC-E301)[RSES] <m.l.wilson@nasa.gov> escreveu:

Thanks for the reply!!  Having some issues due to nulls….  Any other thoughts?

 

i=# ALTER TABLE granule_file ADD PRIMARY KEY (granule_uuid, file_id);

ERROR:  column "granule_uuid" contains null values

Well, uuid is a bad datatype for primary keys.
If possible in the long run, consider replacing them with bigint.

Can you try a index:
CREATE INDEX granule_file_file_id_key ON granule_file USING btree(file_id);

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

My 2cents.

Best regards,
Ranier Vilela

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Wilson, Maria Louise (LARC-E301)[RSES]"
Дата:
Сообщение: Re: [EXTERNAL] Need help with performance tuning pg12 on linux
Следующее
От: "Wilson, Maria Louise (LARC-E301)[RSES]"
Дата:
Сообщение: Re: [EXTERNAL] Need help with performance tuning pg12 on linux