Feature request for adoptive indexes
От
Hayk Manukyan
Тема
Feature request for adoptive indexes
Дата
Msg-id
CAF+kZOHx4noAA2H5hLJSJf=Drt0w8Anhcdh+U=nEB_63HvyM3g@mail.gmail.com
Список
Дерево обсуждения
Feature request for adoptive indexes Hayk Manukyan <manukyantt@gmail.com>
Re: Feature request for adoptive indexes Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: Feature request for adoptive indexes Hayk Manukyan <manukyantt@gmail.com>
Re: Feature request for adoptive indexes Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: Feature request for adoptive indexes Robert Haas <robertmhaas@gmail.com>
Re: Feature request for adoptive indexes Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: Feature request for adoptive indexes Hayk Manukyan <manukyantt@gmail.com>
Re: Feature request for adoptive indexes Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: Feature request for adoptive indexes Pavel Borisov <pashkin.elfe@gmail.com>
Re: Feature request for adoptive indexes Hayk Manukyan <manukyantt@gmail.com>
Re: Feature request for adoptive indexes Pavel Borisov <pashkin.elfe@gmail.com>
Re: Feature request for adoptive indexes Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: Feature request for adoptive indexes Mark Dilger <mark.dilger@enterprisedb.com>
Re: Feature request for adoptive indexes Tom Lane <tgl@sss.pgh.pa.us>
Re: Feature request for adoptive indexes Peter Geoghegan <pg@bowt.ie>
Re: Feature request for adoptive indexes Pavel Borisov <pashkin.elfe@gmail.com>
Re: Feature request for adoptive indexes Peter Geoghegan <pg@bowt.ie>
Re: Feature request for adoptive indexes Hayk Manukyan <manukyantt@gmail.com>
Re: Feature request for adoptive indexes Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: Feature request for adoptive indexes Pavel Borisov <pashkin.elfe@gmail.com>
Re: Feature request for adoptive indexes Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: Feature request for adoptive indexes Hayk Manukyan <manukyantt@gmail.com>
Re: Feature request for adoptive indexes Tomas Vondra <tomas.vondra@enterprisedb.com>
Hi everyone. I want to do some feature request regarding indexes, as far as
I know this kind of functionality doesn't exists in Postgres. Here is my
problem :
I need to create following indexes:
Create index job_nlp_year_scan on ingest_scans_stageing
(`job`,`nlp`,`year`,`scan_id`);
Create index job_nlp_year_issue_flag on ingest_scans_stageing
(`job`,`nlp`,`year`,`issue_flag`);
Create index job_nlp_year_sequence on ingest_scans_stageing
(`job`,`nlp`,`year`,`sequence`);
As you can see the first 3 columns are the same (job, nlp, year). so if I
create 3 different indexes db should manage same job_nlp_year structure 3
times.
The Data Structure that I think which can be efficient in this kind of
scenarios is to have 'Adaptive Index' which will be something like
Create index job_nlp_year on ingest_scans_stageing
(`job`,`nlp`,`year`,(`issue_flag`,`scan_id`, `sequence`));
And depend on query it will use or job_nlp_year_scan or
job_nlp_year_issue_flag , or job_nlp_year_sequence ( job, nlp, year and one
of ( `issue_flag` , `scan_id` , `sequence` )
For more description please feel free to refer me
I know this kind of functionality doesn't exists in Postgres. Here is my
problem :
I need to create following indexes:
Create index job_nlp_year_scan on ingest_scans_stageing
(`job`,`nlp`,`year`,`scan_id`);
Create index job_nlp_year_issue_flag on ingest_scans_stageing
(`job`,`nlp`,`year`,`issue_flag`);
Create index job_nlp_year_sequence on ingest_scans_stageing
(`job`,`nlp`,`year`,`sequence`);
As you can see the first 3 columns are the same (job, nlp, year). so if I
create 3 different indexes db should manage same job_nlp_year structure 3
times.
The Data Structure that I think which can be efficient in this kind of
scenarios is to have 'Adaptive Index' which will be something like
Create index job_nlp_year on ingest_scans_stageing
(`job`,`nlp`,`year`,(`issue_flag`,`scan_id`, `sequence`));
And depend on query it will use or job_nlp_year_scan or
job_nlp_year_issue_flag , or job_nlp_year_sequence ( job, nlp, year and one
of ( `issue_flag` , `scan_id` , `sequence` )
For more description please feel free to refer me
В списке pgsql-hackers по дате отправления