Re: Query kills machine. - Mailing list pgsql-performance

From Stef
Subject Re: Query kills machine.
Date
Msg-id 20040825163041.716d2103@svb.ucs.co.za
Whole thread Raw
In response to Re: Query kills machine.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tom Lane mentioned :
=> Not if you haven't got the RAM to support it :-(
=>
=> Another thing you might look at is ANALYZEing the tables again after
=> you've loaded all the new data.  The row-count estimates seem way off
=> in these plans.  You might need to increase the statistics target,
=> too, to get better plans.

Thanks Tom, Christopher and Magnus!

I tested this, and found the correct sort_mem setting for my situation.
I'm testing a new default_statistics_target setting.
This is something I never considered.

Kind Regards
Stefan

pgsql-performance by date:

Previous
From: "Leeuw van der, Tim"
Date:
Subject: Re: What is the best way to do attribute/values?
Next
From: "David Price"
Date:
Subject: Optimizer Selecting Incorrect Index