Re: [PERFORM] Bad Plan for Questionnaire-Type Query

2009-05-09 Thread Tom Lane
David Blewett writes: > On Fri, May 8, 2009 at 10:00 PM, Tom Lane wrote: >> Thanks. Could I trouble you for one other data point --- about how many >> rows are in each of these tables? > Not a problem: As best I can tell, the selectivity numbers are about what they should be --- for instance,

Re: [PERFORM] Bad Plan for Questionnaire-Type Query

2009-05-09 Thread David Blewett
On Fri, May 8, 2009 at 10:00 PM, Tom Lane wrote: > Thanks. Could I trouble you for one other data point --- about how many > rows are in each of these tables? Not a problem: canvas_dateresponse 263819 canvas_foreignkeyresponse 646484 canvas_integerresponse 875375 canvas_submission

Re: [PERFORM] Slow select performance despite seemingly reasonable query plan

2009-05-09 Thread Laurent Wandrebeck
2009/5/7 David Brain : > Hi, Hi, > > Some answers in-line: > >> >> Has there been a performance *change*, or are you just concerned about a >> query which doesn't seem to use "enough" disc bandwidth? > > Performance has degraded noticeably over the past few days. > >> Certainly random access like t