Postgres 15

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.

select version();
SHOW timezone;

version

PostgreSQL 15.0 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-10), 64-bit

SELECT 1

TimeZone

GB

SHOW

-- Outdated tzdata pg 15.0 (the same works for me on pg 15.2 with OS up to date!)
SELECT * FROM pg_timezone_names WHERE name ~* 'Cairo';

name
abbrev
utc_offset
is_dst

Africa/Cairo
EET
02:00:00
f

posix/Africa/Cairo
EET
02:00:00
f

SELECT 2

-- Outdated tzdata pg 15.0 (the same works for me on pg 15.2 with OS up to date!)
SET timezone = 'Africa/Cairo';
SHOW timezone;

SELECT timestamptz '2022-05-05 23:17:06.461 +0300' AT TIME ZONE 'Africa/Cairo' AS summer22
     , timestamptz '2022-01-05 23:17:06.461 +0300' AT TIME ZONE 'Africa/Cairo' AS winter22
;

SELECT timestamptz '2023-05-05 23:17:06.461 +0300' AT TIME ZONE 'Africa/Cairo' AS summer23
     , timestamptz '2023-01-05 23:17:06.461 +0300' AT TIME ZONE 'Africa/Cairo' AS winter23
;

SELECT now()                    AS now1
     , transaction_timestamp()  AS now2
     , CURRENT_TIMESTAMP        AS now3
;

SET

TimeZone

Africa/Cairo

SHOW

summer22
winter22

2022-05-05 22:17:06.461
2022-01-05 22:17:06.461

SELECT 1

summer23
winter23

2023-05-05 22:17:06.461
2023-01-05 22:17:06.461

SELECT 1

now1
now2
now3

2023-09-20 07:14:22.248752+02
2023-09-20 07:14:22.248752+02
2023-09-20 07:14:22.248752+02

SELECT 1