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

From: Sergei Kornilov <sk(at)zsrv(dot)org>
To: Fred Habash <fmhabash(at)gmail(dot)com>, "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: Re: Simple Query Elapsed Time ~ 3 hrs Using Bitmap Index/Heap Scan
Date: 2018-06-05 14:26:33
Message-ID: 1461841528208793@web51o.yandex.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

regards, Sergei

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Matthew Hall 2018-06-05 14:42:20 Re: Simple Query Elapsed Time ~ 3 hrs Using Bitmap Index/Heap Scan
Previous Message Fred Habash 2018-06-05 14:17:08 Simple Query Elapsed Time ~ 3 hrs Using Bitmap Index/Heap Scan