>> * Proposed changes to allow amgetnext to return the actual index keys, >> allowing certain types of "unindexable" quals to be checked without >> having to fetch the heap entry. For example a LIKE condition could be >> fully checked against the index entry.
In the extreme we could build tuples and push them up several nodes -- even including joins -- before fetching the rest of the attributes from the heap. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers