One of the example queries that 'could' is identical to one that 'could not'.

2021-12-19 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/indexes-index-only-scans.html Description: 11.9.2 lists ```SELECT x FROM tab WHERE x = 'key' AND z < 42;``` as both examples of 'could' and 'could not' use index-only scans. I believe this

Re: One of the example queries that 'could' is identical to one that 'could not'.

2021-12-19 Thread Tom Lane
PG Doc comments form writes: > 11.9.2 lists ```SELECT x FROM tab WHERE x = 'key' AND z < 42;``` as both > examples of 'could' and 'could not' use index-only scans. No, look again: one of the queries uses the indexed column y, and the other uses the non-indexed column z. r

The pg_stop_backup will return one row with three values.

2021-12-19 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/continuous-archiving.html Description: It appears that this may be out of date. pg_stop_backup --- (0/2000138,"STA