Postgres Pro
Downloads
Home   >   mailing lists

Re: Seq Scan cost shown to be (cost=10000000000.00..10000000001.10) - Mailing list pgsql-general

From Amit Langote
Subject Re: Seq Scan cost shown to be (cost=10000000000.00..10000000001.10)
Date
Msg-id CA+HiwqFwCpMjT7DSSMWDfiame67m3cmfEigEXEOc_keY2gt9AQ@mail.gmail.com
Whole thread Raw
In response to Re: Seq Scan cost shown to be (cost=10000000000.00..10000000001.10)  (Victor Yegorov <vyegorov@gmail.com>)
List pgsql-general
Tree view 
> When one uses “enable_” settings to adjust planner behavior, PostgreSQL
> just sets really high costs for the operations affected (like the one you
> see).
>
> As SeqScan is the only possible way to execute your query, it is still
> choosen.
>

I get it. Thanks!

--
Amit Langote

pgsql-general by date:

Previous
From: Amit Langote
Date:
Subject: Re: Seq Scan cost shown to be (cost=10000000000.00..10000000001.10)
Next
From: "P. Broennimann"
Date:
Subject: Document Management System (DMS)