Re: PL/PgSQL Index Usage with Trigger Variables

["Thomas F.O'Connell" <tfo@xxxxxxxxxxxx>]

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