Postgres Pro
Downloads
Home   >   mailing lists

Re: Index Skip Scan - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Index Skip Scan
Date
Msg-id 20190923020204.GA2781@alvherre.pgsql
Whole thread Raw
In response to Re: Index Skip Scan  (Dmitry Dolgov <9erthalion6@gmail.com>)
Responses Re: Index Skip Scan
List pgsql-hackers
Tree view 
On 2019-Sep-22, Dmitry Dolgov wrote:

> > I think multiplying two ScanDirections to watch for a negative result is
> > pretty ugly:
> 
> Probably, but the only alternative I see to check if directions are opposite is
> to check that directions come in pairs (back, forth), (forth, back). Is there
> an easier way?

Maybe use the ^ operator?

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: strong memory leak in plpgsql from handled rollback and lazy cast
Next
From: Amit Kapila
Date:
Subject: Re: pgbench - allow to create partitioned tables