On Fri, Dec 17, 2004 at 10:28:20PM -0600, Tony Caduto wrote: > The function in question does some selects on the table that is being > inserted and without the indexes working it ends up taking a very long time. > > unfortunatly I can't supppy any of the plpgsql function code.
Can you at least post the EXPLAIN ANALYZE output for a query that you think isn't using an index? -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
