Latest Docs http://search.osakos.com/rss.php http://search.osakos.com/rss.php en-us Sat, 19 Jul 2025 06:06:44 GMT Sat, 19 Jul 2025 06:06:44 GMT postgres|postgresql > add sequence-like column in an existing (tmp) table with "BIGSERIAL" http://search.osakos.com/cache.php?key=5a43c2350ed0cdaf50f28ad96a6fc889&uri=https%3A%2F%2Fstackoverflow.com%2Fquestions%2F75740141%2Fpostgres-adding-big-serial-to-an-existing-table http://search.osakos.com/cache.php?key=5a43c2350ed0cdaf50f28ad96a6fc889 Thu, 17 Jul 2025 04:50:38 GMT postgres - How do I decompose ctid into page and row numbers http://search.osakos.com/cache.php?key=b799b06a89dfd039770471e59e99c834&uri=https%3A%2F%2Fdba.stackexchange.com%2Fquestions%2F65964%2Fhow-do-i-decompose-ctid-into-page-and-row-numbers http://search.osakos.com/cache.php?key=b799b06a89dfd039770471e59e99c834 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]]>
Thu, 17 Jul 2025 04:45:13 GMT
Getting Started with Apple’s container CLI on macOS: A Native Alternative to Docker http://search.osakos.com/cache.php?key=5fadd8c741a9675546123f201cf03330&uri=https%3A%2F%2Fswapnasagarpradhan.medium.com%2Fgetting-started-with-apples-container-cli-on-macos-a-native-alternative-to-docker-fc303e08f5cd http://search.osakos.com/cache.php?key=5fadd8c741a9675546123f201cf03330 Wed, 16 Jul 2025 23:22:27 GMT postgresql|postgres > could not resize shared memory segment. No space left on device http://search.osakos.com/cache.php?key=7ffdefc35076e30a1ed9c9e050d14112&uri=https%3A%2F%2Fstackoverflow.com%2Fquestions%2F56751565%2Fpq-could-not-resize-shared-memory-segment-no-space-left-on-device http://search.osakos.com/cache.php?key=7ffdefc35076e30a1ed9c9e050d14112 Wed, 09 Jul 2025 01:08:47 GMT postgres|PostgreSQL > LIKE query performance variations USING GIN http://search.osakos.com/cache.php?key=afcaec46a4ae6eb38f8f27272b935eea&uri=https%3A%2F%2Fstackoverflow.com%2Fquestions%2F1566717%2Fpostgresql-like-query-performance-variations http://search.osakos.com/cache.php?key=afcaec46a4ae6eb38f8f27272b935eea Thu, 26 Jun 2025 07:19:28 GMT