| BML-S | Help Login

Last entries

    20250717.1350

  1. 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;

    2. 20250717.1345

  2. 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

    3. 20250717.0822

  3. Getting Started with Apple’s container CLI on macOS: A Native Alternative to Docker - [s]

    brew install --cask container

    4. 20250709.1008

  4. postgresql|postgres > could not resize shared memory segment. No space left on device - [s]

    5. 20250626.1619

  5. postgres|PostgreSQL > LIKE query performance variations USING GIN - [s]

[s] public (5)