[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Gnumed-devel] enable_seqscan

From: Karsten Hilbert
Subject: Re: [Gnumed-devel] enable_seqscan
Date: Mon, 13 Mar 2006 20:47:51 +0100
User-agent: Mutt/1.5.11+cvs20060126

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>.

GPG key ID E4071346 @
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

reply via email to

[Prev in Thread] Current Thread [Next in Thread]