From: | Hayk Manukyan <manukyantt(at)gmail(dot)com> |
---|---|
To: | Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com> |
Cc: | PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
Subject: | Re: BUG #17246: Feature request for adoptive indexes |
Date: | 2021-10-25 14:08:12 |
Message-ID: | CAF+kZOGcSisy16A6apjiun1tg=3VrQv2u-cX0oOCFhySc9UT8A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Oh sorry,
OK, I cant find the report
Can you close it for me please ?
Best regards
пн, 25 окт. 2021 г. в 17:57, Bharath Rupireddy <
bharath(dot)rupireddyforpostgres(at)gmail(dot)com>:
> On Mon, Oct 25, 2021 at 7:20 PM PG Bug reporting form
> <noreply(at)postgresql(dot)org> wrote:
> >
> > The following bug has been logged on the website:
> >
> > Bug reference: 17246
> > Logged by: Hayk Manukyan
> > Email address: manukyantt(at)gmail(dot)com
> > PostgreSQL version: 14.0
> > Operating system: Any
> > Description:
> >
> > 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
>
> Thanks. What you are proposing looks like a new feature request, it is
> relevant to discuss in pgsql-hackers(at)lists(dot)postgresql(dot)org [1], not
> here in the bugs list and it shouldn't be classified as a bug. Feel
> free to close this bug and start a discussion in the hackers list.
>
> https://www.postgresql.org/list/
>
> Regards,
> Bharath Rupireddy.
>
From | Date | Subject | |
---|---|---|---|
Next Message | Dmitry Dolgov | 2021-10-25 14:53:07 | Re: ERROR: posting list tuple with 20 items cannot be split at offset 168 |
Previous Message | Bharath Rupireddy | 2021-10-25 13:56:56 | Re: BUG #17246: Feature request for adoptive indexes |