Postgres Pro
Downloads
Home   >   mailing lists

Re: Simple Query Elapsed Time ~ 3 hrs Using Bitmap Index/Heap Scan - Mailing list pgsql-performance

From Sergei Kornilov
Subject Re: Simple Query Elapsed Time ~ 3 hrs Using Bitmap Index/Heap Scan
Date
Msg-id 1461841528208793@web51o.yandex.ru
Whole thread Raw
In response to Simple Query Elapsed Time ~ 3 hrs Using Bitmap Index/Heap Scan  (Fred Habash <fmhabash@gmail.com>)
List pgsql-performance
Tree view 
Hello
Try using index btree(vclf_number, cl_value) instead of btree (vclf_number).

regards, Sergei

pgsql-performance by date:

Previous
From: Fred Habash
Date:
Subject: Simple Query Elapsed Time ~ 3 hrs Using Bitmap Index/Heap Scan
Next
From: Matthew Hall
Date:
Subject: Re: Simple Query Elapsed Time ~ 3 hrs Using Bitmap Index/Heap Scan