My database version is 9.3 but I have test with 9.4 too with the same
result, and I have test changing that parameter without success.
I want to know what does have to do the trim with the different query plans?
2015-11-25 13:35 GMT-03:00 Evgeniy Shishkin :
> > What is your Postgres version?
> >
I have a query that produce a different query plan if I put a trim in one
of the columns in the order by.
When i put the trim in any column it use hashaggregate and took 3 seconds
against 30 when not.
Is wear because the columns is clean not need to be trimmed, I have check
that.
The problem
