Re: [9.2devel] why it doesn't do index scan only?

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Thom Brown <thom(at)linux(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, depesz(at)depesz(dot)com, pgsql-general(at)postgresql(dot)org
Subject: Re: [9.2devel] why it doesn't do index scan only?
Date: 2011-10-08 18:47:29
Message-ID: CAFj8pRD993VN2__=sUM1_sKB6S28BWej5Ay4UZ1QKJozajpAhA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thom Brown 2011-10-08 19:04:21 Re: [9.2devel] why it doesn't do index scan only?
Previous Message Thom Brown 2011-10-08 18:41:55 Re: [9.2devel] why it doesn't do index scan only?