PostgreSQL Collation Version, Very Slow App/Database Calls
capkz
HOBBYOP

6 months ago

I started seeing this error in my logs more and more, and I noticed around this time a big performance detoriation within my app. Sometimes pages won't even open, I believe database requiring calls got way more slower, even so I sometimes noticed building my Dockerfile went from af ew minutes to 10+ minutes.
I then ran the command that it gave me ALTER DATABASE postgres REFRESH COLLATION VERSION, and I notice that performance is still bad despite the error being gone.
I am not even sure if this is DB or Workspace related, but really need help here.

Here is the error I started seeing:
Rebuild all objects in this database that use the default collation and run ALTER DATABASE postgres REFRESH COLLATION VERSION, or build PostgreSQL with the right library version." AND "2025-08-31 09:44:38.458 UTC [5010] HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE postgres REFRESH COLLATION VERSION, or build PostgreSQL with the right library version."

0 Replies

Loading...