Re: [PERFORM] how to help the planner

2013-03-28 Thread Marty Frasier
the source codes but don't know how to take advantage of them or whether it would be of use. I suppose the answer could eventually be we have to reorganize our queries? Thanks, Marty On Thu, Mar 28, 2013 at 12:18 PM, Tom Lane wrote: > Marty Frasier writes: > > We've been us

[PERFORM] how to help the planner

2013-03-28 Thread Marty Frasier
y and tried it with default_statistics_target=1 to see if that helped. It didn't. The table is static - no new rows are being added and there is no other load on the database. schema dump: http://pastebin.com/pUU0BJvr What can we do to help the planner estimate better? Thanks in advance, Marty Frasier