Postgres Pro
Downloads
Home   >   mailing lists

Re: [PERFORM] Cheaper subquery scan not considered unless offset 0 - Mailing list pgsql-performance

From David Rowley
Subject Re: [PERFORM] Cheaper subquery scan not considered unless offset 0
Date
Msg-id CAKJS1f-0aAOKV=0L_fqzRUuVfrVi2v5izJGGNrJ-9x_PgfuhDQ@mail.gmail.com
Whole thread Raw
In response to [PERFORM] Cheaper subquery scan not considered unless offset 0  (Benjamin Coutu <ben.coutu@zeyos.com>)
List pgsql-performance
Tree view 
On 30 October 2017 at 00:24, Benjamin Coutu <ben.coutu@zeyos.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=15521total=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


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

pgsql-performance by date:

Previous
From: Benjamin Coutu
Date:
Subject: [PERFORM] Cheaper subquery scan not considered unless offset 0
Next
From: Benjamin Coutu
Date:
Subject: Re: [PERFORM] Cheaper subquery scan not considered unless offset 0