On Mon, Mar 13, 2006 at 02:39:17PM +0800, Syan Tan wrote: > I've run vacuum analyze too, that didn't help. The weird thing is that if > selecting on pk_episode, it runs with index_scan, but if selecting on > pk_health_issue, it > won't (this is for clin.v_pat_items). still trying to figure out why. I'm > suspecting > still it's something to do with the indirection of an extra join. If we can't resolve this I think we have a fair case to present to <pgsql-performance>.
Karsten -- GPG key ID E4071346 @ wwwkeys.pgp.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346 _______________________________________________ Gnumed-devel mailing list [email protected] http://lists.gnu.org/mailman/listinfo/gnumed-devel
