Re: [Gnumed-devel] enable_seqscan

[Karsten Hilbert]

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