Re: [HACKERS]WIP: Covering + unique indexes.

2015-12-26 Thread Jeff Janes
On Sat, Dec 26, 2015 at 5:58 PM, Jeff Janes wrote: > > And the dblink contrib module fails its make check. Ignore the dblink complaint. It seems to have been some wonky build issue that is not reproducible. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes

Re: [HACKERS]WIP: Covering + unique indexes.

2015-12-26 Thread Jeff Janes
On Tue, Dec 1, 2015 at 4:53 AM, Anastasia Lubennikova wrote: > Finally, completed patch "covering_unique_3.0.patch" is here. > It includes the functionality discussed above in the thread, regression > tests and docs update. > I think it's quite ready for review. Thanks for the patch. I get a com

Re: [HACKERS]WIP: Covering + unique indexes.

2015-12-04 Thread Anastasia Lubennikova
03.12.2015 04:03, Robert Haas пишет: On Tue, Dec 1, 2015 at 7:53 AM, Anastasia Lubennikova wrote: If we don't need c4 as an index scankey, we don't need any btree opclass on it. But we still want to have it in covering index for queries like SELECT c4 FROM tbl WHERE c1=1000; // uses the Inde

Re: [HACKERS]WIP: Covering + unique indexes.

2015-12-02 Thread Robert Haas
On Tue, Dec 1, 2015 at 7:53 AM, Anastasia Lubennikova wrote: > If we don't need c4 as an index scankey, we don't need any btree opclass on > it. > But we still want to have it in covering index for queries like > > SELECT c4 FROM tbl WHERE c1=1000; // uses the IndexOnlyScan > SELECT * FROM tbl WHE

Re: [HACKERS]WIP: Covering + unique indexes.

2015-12-01 Thread Anastasia Lubennikova
Finally, completed patch "covering_unique_3.0.patch" is here. It includes the functionality discussed above in the thread, regression tests and docs update. I think it's quite ready for review. _Future work:_ Besides that, I'd like to get feedback about attached patch "optional_opclass_3.0.pat

Re: [HACKERS]WIP: Covering + unique indexes.

2015-10-09 Thread Anastasia Lubennikova
08.10.2015 19:31, Thom Brown пишет: On 8 October 2015 at 16:18, Anastasia Lubennikova wrote: Hi hackers, I'm working on a patch that allows to combine covering and unique functionality for btree indexes. Previous discussion was here: 1) Proposal thread 2) Message with proposal clarification

Re: [HACKERS]WIP: Covering + unique indexes.

2015-10-08 Thread Thom Brown
On 8 October 2015 at 16:18, Anastasia Lubennikova wrote: > > Hi hackers, > > I'm working on a patch that allows to combine covering and unique > functionality for btree indexes. > > Previous discussion was here: > 1) Proposal thread > 2) Message with proposal clarification > > In a nutshell, the f

[HACKERS]WIP: Covering + unique indexes.

2015-10-08 Thread Anastasia Lubennikova
Hi hackers, I'm working on a patch that allows to combine covering and unique functionality for btree indexes. _Previous discussion was here:_ 1) Proposal thread 2) Message with proposal clarification

<    1   2