[External] Join queries slow with predicate, limit, and ordering

2019-12-02 Thread Aufar Gilbran
cker Installation: - MacOSX: PostgreSQL is installed by using brew. - Docker: PostgreSQL image from https://hub.docker.com/_/postgres. I use the default configuration provided in all of these environments. Thanks! -- Best regards, Aufar Gilbran -- *_Grab is hiring. Learn more at _**https://gra

Re: [External] Join queries slow with predicate, limit, and ordering

2019-12-03 Thread Aufar Gilbran
e it cannot consult the index for the ordering anymore so it can't do LIMIT? I'm not so sure. [1] https://explain.depesz.com/s/aEmR [2] https://explain.depesz.com/s/kmNY [3] https://explain.depesz.com/s/pD5v [4] https://explain.depesz.com/s/4s7Q -- Best regards, Aufar Gilbran -- *_Grab is hi