[wp-trac] [WordPress Trac] #45354: Adding index for meta_key and post_id in postmeta

[WordPress Trac]

#45354: Adding index for meta_key and post_id in postmeta
----------------------------------------+------------------------------
 Reporter:  DuckDagobert                |       Owner:  (none)
     Type:  enhancement                 |      Status:  new
 Priority:  normal                      |   Milestone:  Awaiting Review
Component:  Database                    |     Version:
 Severity:  normal                      |  Resolution:
 Keywords:  needs-testing dev-feedback  |     Focuses:  performance
----------------------------------------+------------------------------

Comment (by johnbillion):

 Additional indexes also take up disk space. Ironically the sites that
 would benefit the most from this additional index would also experience
 the greatest increase in space usage. (I'm not against the change, just
 pointing this out.)

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/45354#comment:8>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform