Moderators (requests and notices)

You are reading a single comment by @Velocio and its replies. Click here to read the full conversation.

•

cyclotron3k in reply to @Velocio

What version of postgres is lfgss on? Pre 9.6 wasn't multithreaded, and pre 12, CTEs (and sub queries?) were basically optimisation fences.

If a DISTINCT ON causes performance issues, upgrading postgres could be a solution

•

Velocio in reply to @cyclotron3k

At this point in time I may have to admit it's an old PostgreSQL version.

If anyone is extremely comfortable with upgrading Postgres please let me know, would love to get us to latest stable.

We are on 9.2 with the ltree module installed.

About

Avatar for Velocio @Velocio started