On 2013-07-04 02:32:32 +0900, Michael Paquier wrote: > > Wouldn't it make more sense to fetch the toast index oid in the query > > ontop instead of making a query for every relation? > With something like a CASE condition in the upper query for > reltoastrelid? This code path is not only taken by indexes but also by > tables. So I thought that it was cleaner and more readable to fetch > the index OID only if necessary as a separate query.
A left join should do the trick? Greetings, Andres Freund -- Andres Freund http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers