Postgres Pro
Downloads
Home   >   mailing lists

Re: SELECT performance drop - Mailing list pgsql-performance

From Jan Nielsen
Subject Re: SELECT performance drop
Date
Msg-id CANxH4hGKLRzeyajh1ZQPhkveCgNHDuiatof-HOWXDJ4kbnJPzQ@mail.gmail.com
Whole thread Raw
In response to RE:SELECT performance drop  (legrand legrand <legrand_legrand@hotmail.com>)
Responses Re: SELECT performance drop
List pgsql-performance
Tree view


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


 

regards
PAscal

pgsql-performance by date:

Previous
From: Arne Roland
Date:
Subject: RE: dsa_allocate() faliure
Next
From: Jan Nielsen
Date:
Subject: Re: SELECT performance drop