[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>.
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346