It looks like the indexes are in fact used when trigger variables are referenced in where clauses in PL/pgSQL. Thanks for the idea of investigating the plans in the logs for this info.

Follow-up question: are indexes used in dynamically executed queries?

Rather than SEQSCAN or INDEXSCAN in the DETAIL item, I see RESULT followed by a large amount of unreadable (by me) output.

-tfo

--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005


---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend

Reply via email to