Home
About
Download
Documentation
Community
Developers
Support
Donate
Your account
Quick Links
Community
Contributors
Mailing Lists
IRC
Local User Groups
Events
International Sites
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:
2018-06-05 14:17:08 from Fred Habash <fmhabash(at)gmail(dot)com>
2018-06-05 14:26:33 from Sergei Kornilov <sk(at)zsrv(dot)org>
2018-06-05 14:42:20 from Matthew Hall <mhall(at)mhcomputing(dot)net>
2018-06-05 17:18:10 from Fd Habash <fmhabash(at)gmail(dot)com>
2018-06-05 14:42:22 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Lists:
pgsql-performance
Hello
Try using index btree(vclf_number, cl_value) instead of btree (vclf_number).
regards, Sergei
In response to
Simple Query Elapsed Time ~ 3 hrs Using Bitmap Index/Heap Scan
at 2018-06-05 14:17:08 from Fred Habash
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