Re: [PERFORM] Planner problem

2004-06-04 Thread Tom Lane
=?ISO-8859-1?Q?Mikael_Kjellstr=F6m?= <[EMAIL PROTECTED]> writes: > I am having a bit of problem with the plan that the planner produces. Actually, your problem is with the row-count estimates. Some of them are pretty wildly off, which inevitably leads to bad plan choices. In particular the price

[PERFORM] Planner problem

2004-06-04 Thread Mikael Kjellström
Hi! I am having a bit of problem with the plan that the planner produces. First a little info: OS: Linux Debian Version: PostgreSQL 7.4.2 on i686-pc-linux-gnu, compiled by GCC gcc GCC) 3.3.3 (Debian 20040401) CPU: AMD Athlon XP 2000+ Memory: 1GB Disk: 4 SCSI-3 UW 1rpm in RAID 1 (mirror) mode