← Back to team overview

maria-developers team mailing list archive

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 :)

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