Re: [PERFORM] A query become very slow after upgrade from 8.1.10 to 8.4.5

2010-11-02 Thread Yaocl
On Wed, Nov 3, 2010 at 6:30 AM, Tom Lane wrote: > Yaocl writes: >> SELECT t_a.id FROM t_a >> WHERE EXISTS ( SELECT t_b.id FROM t_b, t_c >>                WHERE t_b.id = t_a.id AND t_c.flag = 'f') > > I have some hopes for fixing this in 9.1, but nothing is

[PERFORM] A query become very slow after upgrade from 8.1.10 to 8.4.5

2010-11-01 Thread Yaocl
Hi Sorry, my previous post haven't shown in this list, so I repost this one. I have a sql become very slow after upgrade to 8.4.5. The table creation sql like this. begin; CREATE TABLE t_a ( id INT NOT NULL PRIMARY KEY ); CREATE TABLE t_b ( id INT NOT NULL PRIMARY KEY ); CREATE TA