Re: [9.2devel] why it doesn't do index scan only? - Mailing list pgsql-general

From Pavel Stehule
Subject Re: [9.2devel] why it doesn't do index scan only?
Date
Msg-id CAFj8pRD993VN2__=sUM1_sKB6S28BWej5Ay4UZ1QKJozajpAhA@mail.gmail.com
Whole thread Raw
In response to Re: [9.2devel] why it doesn't do index scan only?  (Thom Brown <thom@linux.com>)
Responses Re: [9.2devel] why it doesn't do index scan only?  (Thom Brown <thom@linux.com>)
List pgsql-general
>> I did it. It is strange, so your times are significantly slower than I
>> have. Have you enabled asserts?
>
> The table contains 15 million rows with column values randomly
> selected from the 1-350 range, with 60% within the 1-50 range, and
> asserts are enabled.
>

Now I repeated tests on litlle bit wide table with 9 milion rows, but
without success.

Try to disable asserts. I am not sure, but maybe there significantlly
change a speed.

Pavel

pgsql-general by date:

Previous
From: Thom Brown
Date:
Subject: Re: [9.2devel] why it doesn't do index scan only?
Next
From: Thom Brown
Date:
Subject: Re: [9.2devel] why it doesn't do index scan only?