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?.
CREATE TEMPORARY TABLE locations (
id INT, prof_id INT, lat NUMERIC, long NUMERIC
);
INSERT INTO locations VALUES
(57,58,47.5327567434237,21.6292262077332);
UPDATE locations SET lat = 48.20325265836398, long = 16.34969524923078
WHERE prof_id = 58 AND lat = 47.5327567434237 AND long = 21.6292262077332;
SELECT * FROM locations;
CREATE TABLE
INSERT 0 1
UPDATE 1
| id | prof_id | lat | long |
|---|---|---|---|
| 57 | 58 | 48.20325265836398 | 16.34969524923078 |
SELECT 1