maria-developers team mailing list archive
-
maria-developers team
-
Mailing list archive
-
Message #11050
Re: Partial indexes?
Hi Jared.
I read your pg link in detail a couple of times and this could be interesting for MySQL users,especially those implementing large time-series databases and some multi-tenant scenarios.
Can you write up the jira as requested and I'll comment more there?
(Note that example 11.3 can be accomplished in both pg and MySQL usingNULLs in a unique index, but the pg partial index allows the original data valuesto be used without a NULL work column, so might be slightly more convenient/obvious.)
Thanks, James Briggs.
--
Cassandra/MySQL DBA. Available in San Jose area or remote.
cass_top: https://github.com/jamesbriggs/cassandra-top
From: Sergei Golubchik <serg@xxxxxxxxxxx>
To: Jared Beck <jared@xxxxxxxxxxxxx>
Cc: maria-developers@xxxxxxxxxxxxxxxxxxx
Sent: Wednesday, December 27, 2017 12:30 PM
Subject: Re: [Maria-developers] Partial indexes?
Hi, Jared!
On Dec 27, Jared Beck wrote:
> Dear Maria,
>
> :p
>
> Thanks for all your hard work!
>
> Any plans to implement partial indexes?
> (https://www.postgresql.org/docs/10/static/indexes-partial.html)
No such plans at the moment.
What do you you need them for?
> I hope this is the right place to suggest new features. Please
> redirect me if not.
To suggest a new feature, you can create a task at jira.mariadb.org
(presuming such a task doesn't exist yet).
But a mailing list is a better place if you want to start a discussion.
If, for example, you'd like to show valid use cases for partial indexes
or explain why it's an important feature to have :)
Regards,
Sergei
Chief Architect MariaDB
and security@xxxxxxxxxxx
_______________________________________________
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~maria-developers
More help : https://help.launchpad.net/ListHelp
References