I have a Wordpress site, and as a result of a plugin, my posts and postmeta table IDs got set to autoincrement at 9004111220000000 and up. I didn't notice until I had 10s of thousands of IDs like that.

My question is, is this a significant enough hit to performance that I should do something about it?

  • 2
    BIGINT size does not depend on the value.
    – Akina
    Commented Oct 18, 2021 at 5:59
  • It would sure be nice to know which plugin did this...
    – O. Jones
    Commented Feb 17, 2022 at 12:20

1 Answer 1


Given its still a 64bit number << 2^64-1 (the BIGINT UNSIGNED maximum, that I assume posts and postmeta uses) its ok. It uses more bits of a bigint than usual, but its ok.

I wouldn't expect a degradation because of this.

If you still use the plugin, I hope you see what it is doing.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.