Re: adjust_limit_rows_costs algorithm

On 24/12/2024 08:20, wenhui qiu wrote: sysbench=# explain analyze  select userid from dba_users where  username like '%%' order by userid limit 1;                                                                  QUERY PLAN

adjust_limit_rows_costs algorithm

Hi Hackers There should be many people who have encountered the problem of order by col limit 1 without index filtering,Here is an example of my test create extension pg_trgm ; CREATE TABLE public.dba_users ( userid integer primary key, username character varying(64), password character varyin