[PERFORM] Problem with mergejoin performance (some bug?)

2010-09-16 Thread azajac
I have a problem with some simple query: select version(); PostgreSQL 8.3.8 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.3.2 20081105 (Red Hat 4.3.2-7) vacuum full bug_t1; vacuum full bug_t2; vacuum analyze bug_t1; vacuum analyze bug_t2; explain analyze SELECT ze.id ,rr.id FROM bug_t2 AS rr

[PERFORM] Problem with mergejoin performance

2010-09-12 Thread azajac
I have a problem with some simple query: select version(); PostgreSQL 8.3.8 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.3.2 20081105 (Red Hat 4.3.2-7) vacuum full bug_t1; vacuum full bug_t2; vacuum analyze bug_t1; vacuum analyze bug_t2; show default_statistics_target; 1000 e