For our production PGSQL databases, we use a combination of PGTuner[0] to help estimate RAM requirements and PGHero[1] to get a live view of the running DB. Furthermore, we use ZFS with the built-in compression to save disk space. Together, these three utilities help keep our DBs running very well. [0] https://pgtune.leopard.in.ua [1] https://github.com/ankane/pghero. - Source: Hacker News / 4 days ago

I am using https://github.com/ankane/pghero/ and this is one of its features with GUI. - Source: Hacker News / 2 months ago

I use either PgHero or Rails PG Extras on every project. Source: 12 months ago

There are tools available which can look at your Postgres logs and tell you if you need to add indexes, I've used https://github.com/ankane/pghero before and it seems decent. Source: about 1 year ago

I'm a huge supporter of PGhero (https://github.com/ankane/pghero) for this reason. Sometimes a single index is all that's required, but if DB design isn't your forte it's hard to know where to put it. - Source: Hacker News / over 2 years ago

I also like WP Rocket's database cleaning tool: https://wp-rocket.me/. Source: about 1 year ago

This will have a serious impact based on that kind of database. A good caching plug-in like WP Rocket should help with the overheads and speed things up. If you have server side caching like memcached or lighspeed make sure you are utilising it. Source: about 1 year ago

Purchase a license from the WP Rocket website (https://wp-rocket.me/). Source: about 1 year ago

Sounds like your colleague bought a nulled/"GPL free" copy of WP Rocket - probably not purchased from https://wp-rocket.me/. Source: over 1 year ago

One of the most beloved WordPress caching plugins is WP Rocket. They’ve managed to take something complex and make it extremely easy, yet still powerful and configurable. They have also made it easy to integrate with a CDN in just a few clicks. - Source: dev.to / over 1 year ago