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,
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
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