Re: Simple Query Elapsed Time ~ 3 hrs Using Bitmap Index/Heap Scan

From: Sergei Kornilov
Subject: Re: Simple Query Elapsed Time ~ 3 hrs Using Bitmap Index/Heap Scan
Date: ,
Msg-id: 1461841528208793@web51o.yandex.ru
(view: Whole thread, Raw)
In response to: Simple Query Elapsed Time ~ 3 hrs Using Bitmap Index/Heap Scan  (Fred Habash)
List: pgsql-performance


Hello
Try using index btree(vclf_number, cl_value) instead of btree (vclf_number).

regards, Sergei



pgsql-performance by date:

From: Fd Habash
Date:
Subject: RE: Simple Query Elapsed Time ~ 3 hrs Using Bitmap Index/Heap Scan
From: e-blokos
Date:
Subject: Re: Client Server performance & UDS