| From: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
|---|---|
| To: | Kenny Bachman <kenny(dot)bachman17(at)gmail(dot)com> |
| Cc: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: postrgesql query planner wrong desicion |
| Date: | 2022-06-18 15:36:45 |
| Message-ID: | CAMkU=1yz+e77KzUcemnspg_AOJvxzDxh+j-b1_8f_o3uL5HVAQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Fri, Jun 17, 2022 at 4:48 AM Kenny Bachman <kenny(dot)bachman17(at)gmail(dot)com>
wrote:
> Hello Team,
>
> I have a 12.11 postgresql database on Linux. When I ran the below query,
> the query planner uses the gist index. However, the query runs faster if I
> drop the gist index, because the query planner uses the b-tree index. Why
> does the query planner use the gist index instead of the b-tree?
>
Please show the definition of both indexes. Also, eliminate the joins and
where clause conditions which are not needed to reproduce the base problem,
then show the full plans, not just one line.
Cheers,
Jeff
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Janes | 2022-06-19 20:33:33 | Re: postrgesql query planner wrong desicion |
| Previous Message | Kenny Bachman | 2022-06-18 06:41:38 | Re: postrgesql query planner wrong desicion |