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

 @johnbillion Any thoughts on making `post_id` the primary index (easier)
 or changing the way WordPress retrieves meta data (faster)?

 Looks like disk space is now taken up by indexes that don't help (as much
 as they could), and some of those can be removed in favour of better ones.

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