Re: [PERFORM] Improving join performance over multiple moderately wide tables

2009-10-18 Thread Robert Haas
On Fri, Oct 16, 2009 at 5:12 PM, miller_2555 wrote: >  [...snip...] attempted to set the `join_collapse_limit` to '1' [...] That seems like an odd thing to do - why did you do this? What happens if you don't? I have never seen anything like the bizarrely large row estimates that you have here.

[PERFORM] Improving join performance over multiple moderately wide tables

2009-10-17 Thread miller_2555
Hi - I'm stuck on a query performance issue, and I would sincerely appreciate any server setting/ query improvement suggestions. I am attempting to retrieve records stored in 20 tables that are related to a one or more records in a single table (let's call the 20 tables `data tables` and the