Postgres Pro
Downloads
Home   >   mailing lists

Re: Planner chooses slow index heap scan despite accurate row estimates - Mailing list pgsql-performance

From Jake Magner
Subject Re: Planner chooses slow index heap scan despite accurate row estimates
Date
Msg-id 1464391854473-5905383.post@n5.nabble.com
Whole thread Raw
In response to Re: Planner chooses slow index heap scan despite accurate row estimates  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Re: Planner chooses slow index heap scan despite accurate row estimates  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tree view 
I tried without doing an INSERT at all, just running the SELECT queries and
the result is the same. Nested loop is chosen but is much slower.



--
View this message in context:
http://postgresql.nabble.com/Planner-chooses-slow-index-heap-scan-despite-accurate-row-estimates-tp5905357p5905383.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Planner chooses slow index heap scan despite accurate row estimates
Next
From: Tom Lane
Date:
Subject: Re: Re: Planner chooses slow index heap scan despite accurate row estimates