Re: BUG #13817: Query planner strange choose while select/count small part of big table - complete

On 2015-12-14 11:45:27 +0000, sienkomarcin(at)gmail(dot)com wrote:
> The following bug has been logged on the website:
>
> Bug reference: 13817
> Logged by: Marcin_S
> Email address: sienkomarcin(at)gmail(dot)com
> PostgreSQL version: 9.4.5
> Operating system: Windows 7 x64
> Description:
>
> Hi,
>
> First sorry for not completed last bug (browser handle it too fast :). Here
> is complete version:
>
>
> I've check todo list but i can't find exact problem i'm reporting. It seems
> like query planner fires not needed sequence scan by all rows in table when
> only a few rows were picked.

Can you try this with version 9.5 (currently in beta)? This looks very
similar to a problem I reported some time ago and which is fixed in 9.5.

hp

--
_ | Peter J. Holzer | I want to forget all about both belts and
|_|_) | | suspenders; instead, I want to buy pants
| | | hjp(at)hjp(dot)at | that actually fit.
__/ | http://www.hjp.at/ | -- http://noncombatant.org/