Last entries
-
postgres|postgresql > add sequence-like column in an existing (tmp) table with "BIGSERIAL" - [s]
ALTER TABLE tmp_orphaned_metadata_checklist ADD COLUMN id BIGSERIAL PRIMARY KEY;
-
postgres - How do I decompose ctid into page and row numbers - [s]
nxrm108015=> select ctid, (ctid::text::point)[0]::bigint as ctid1, (ctid::text::point)[1]::bigint as ctid2 from tmp_orphaned_metadata_checklist limit 10; ctid | ctid1 | ctid2 --------+-------+------- (0,1) | 0 | 1 (0,2) | 0 | 2 (0,3) | 0 | 3 (0,4) | 0 | 4 (0,5) | 0 | 5 (0,6) | 0 | 6 (0,7) | 0 | 7 (0,8) | 0 | 8 (0,9) | 0 | 9 (0,10) | 0 | 10 (10 rows) (ctid::text::point)[0]::bigint * 100000000 + (ctid::text::point)[1]::bigint as id
-
Getting Started with Appleās container CLI on macOS: A Native Alternative to Docker - [s]
brew install --cask container
-
postgresql|postgres > could not resize shared memory segment. No space left on device - [s]
-
postgres|PostgreSQL > LIKE query performance variations USING GIN - [s]
20250717.1350
20250717.1345
20250717.0822
20250709.1008
20250626.1619