Moderators (requests and notices)

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

•

Velocio in reply to @cyclotron3k

Oooh... I forgot all about SELECT DISTINCT ON despite having used it once in the past.

I think that would work.

•

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 cyclotron3k @cyclotron3k started