Re: SELECT performance drop

Поиск
Список
Период
Сортировка
От Jan Nielsen
Тема Re: SELECT performance drop
Дата
Msg-id CANxH4hGKLRzeyajh1ZQPhkveCgNHDuiatof-HOWXDJ4kbnJPzQ@mail.gmail.com
обсуждение исходный текст
Ответ на RE:SELECT performance drop  (legrand legrand <legrand_legrand@hotmail.com>)
Ответы Re: SELECT performance drop
Список pgsql-performance


On Wed, Jan 23, 2019 at 12:37 PM legrand legrand <legrand_legrand@hotmail.com> wrote:
Hi,
is there an index on
 fm_order(session_id,type)?

There isn't at the moment:

   table_name   |          index_name          | column_name  
----------------+------------------------------+-------------
fm_account     | fm_account_pkey              | id
fm_account     | uk_5p6qalvucbxmw9u64wf0aif9d | name
fm_allocation  | fm_allocation_pkey           | id
fm_approval    | fm_approval_pkey             | id
fm_capital     | fm_capital_pkey              | id
fm_grant       | fm_grant_pkey                | id
fm_market      | fm_market_pkey               | id
fm_marketplace | fm_marketplace_pkey          | id
fm_order       | fm_order_pkey                | id
fm_person      | fm_person_pkey               | id
fm_session     | fm_session_pkey              | id
fm_trader      | fm_trader_pkey               | id


 

regar
ds
PAscal

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

Предыдущее
От: Arne Roland
Дата:
Сообщение: RE: dsa_allocate() faliure
Следующее
От: Jan Nielsen
Дата:
Сообщение: Re: SELECT performance drop