[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:  7.1
Component:  Database                             |     Version:
 Severity:  normal                               |  Resolution:
 Keywords:  needs-testing dev-feedback has-      |     Focuses:
  patch has-unit-tests                           |  performance
-------------------------------------------------+-------------------------

Comment (by galbaras):

 I see the PR is adding the `meta_key, post_id` index that was initially
 proposed, but @fliespl actually tested `post_id, meta_key`, which makes
 more sense.

 Also, making `post_id, meta_key` could speed things up further.

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