Re: Cheaper subquery scan not considered unless offset 0

From: David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>
To: Benjamin Coutu <ben(dot)coutu(at)zeyos(dot)com>
Cc: postgres performance list <pgsql-performance(at)postgresql(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: Cheaper subquery scan not considered unless offset 0
Date: 2017-10-29 11:46:42
Message-ID: CAKJS1f-0aAOKV=0L_fqzRUuVfrVi2v5izJGGNrJ-9x_PgfuhDQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 30 October 2017 at 00:24, Benjamin Coutu <ben(dot)coutu(at)zeyos(dot)com> wrote:
> -> Index Scan using "PK_items_ID" on items a (cost=0.42..1.05 rows=1 width=332) (actual time=0.003..0.003 rows=1 loops=15521 total=46.563)

I've never seen EXPLAIN output like that before.

Is this some modified version of PostgreSQL?

--
David Rowley http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Benjamin Coutu 2017-10-29 13:17:19 Re: Cheaper subquery scan not considered unless offset 0
Previous Message Benjamin Coutu 2017-10-29 11:24:20 Cheaper subquery scan not considered unless offset 0