Rob Sargent wrote: > I have a query I cannot tame and I'm wondering if there's an alternative > to the "between" clause I'm using. Perhaps a custom type could do > better? I've tried the "<@" orperator and that changes the query plan > significantly but the execution cost/time is not improved. > > Any suggestion or pointers much appreciated.
You really need EXPLAIN (ANALYZE, BUFFERS) output to be able to undersrand what is going on. A couple of simple things to check: - Have all tables been ANALYZED beforehand? - Are all optimizer database parameters identical? Also, to have PostgreSQL inline the function, which would be good for performance, it should be declared IMMUTABLE. Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
