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 using
NULLs in a unique index, but the pg partial index allows the original data values
to 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@mariadb.org>
To: Jared Beck <jared@jaredbeck.com>
Cc: maria-developers@lists.launchpad.net
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@mariadb.org


_______________________________________________
Mailing list: https://launchpad.net/~maria-developers
Post to    : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help  : https://help.launchpad.net/ListHelp