Re: Why Postgres doesn't use TID scan?

From: Vladimir Ryabtsev <greatvovan(at)gmail(dot)com>
To: andrew(at)tao11(dot)riddles(dot)org(dot)uk
Cc: tgl(at)sss(dot)pgh(dot)pa(dot)us, pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Why Postgres doesn't use TID scan?
Date: 2018-12-19 23:44:58
Message-ID: CAMqTPqnDhk5TCK6urjGtd=_g6iecxdZVKu9r1jOS=YnF2n6fHA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> The fundamental issue is that "ANY" has two meanings in PG, one of them
following the SQL standard and one not:

Oh yes, I was aware about two forms but it did not come into my mind, I was
thinking I use the same form in both cases since my query returns only one
row and column.
Thanks for pointing me into that.

--
Vlad

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Rick Otten 2018-12-20 13:46:04 Re: Why Postgres doesn't use TID scan?
Previous Message Andrew Gierth 2018-12-19 22:23:15 Re: Why Postgres doesn't use TID scan?