From: "Tom Lane" <[EMAIL PROTECTED]>
Mattias Kregert <[EMAIL PROTECTED]> writes:
Why does it come up with this strange plan?
Because 8.1 can't reorder outer joins. To devise the plan you want,
the planner has to be able to prove that it's OK to perform
From: "Steinar H. Gunderson" <[EMAIL PROTECTED]>
On Mon, Oct 30, 2006 at 01:05:07PM +0200, Mattias Kregert wrote:
-> Hash Left Join (cost=59.66..206763.11 rows=1215336
width=27) (actual time=4.959..3228.550 rows=1216434 loops=1)
Hash Cond: (("ou
Look at this insane plan:
lucas=# explain analyse select huvudklass,sum(summa) from kor_tjanster left
outer join prislist on prislista=listid and tjanst=tjanstid where kor_id in
(select id from kor where lista=10484) group by 1;
QU
I have noticed that a lot of people have a hard
time finding out how to tune postgresql to suit their hardware.
Are there any tools for automatic tuning of the
parameters in postgresql.conf? A simple program
running some benchmarks on cpu & disk speed, checking the amount of ram
and so on
