Vertica 8.1.1-6

This issues only 8.1.1-6 ? I have 8.1.1-8 in prod, Do I need to update?

@sergey_h - The fix is in Vertica 8.1.1-9. So if using Vertica 8.1.1-8, you can potentially encounter this issue where you'll see a sudden drop in performance after the database is UP for few days.

The actual fix is labeled as "VER-58838 / Catalog Engine / The Vertica garbage collector algorithm has been modified to prevent query slowdown."

See:
https://my.vertica.com/docs/ReleaseNotes/8.1.x/Vertica_8.1.x_Release_Notes.htm#8.1.1-9

Jim - what version is the original issue in? If you're running a version prior to 8.1.1.6 (like 8.1.1.2) do you need to upgrade?

thank you!

The "issue" was introduced in 8.1.1-6. So 8.1.1-2 is okay. But when upgrading, make sure to upgrade to at least 8.1.1-9, where the "issue" was rectified.

thanks for the clarification!