BibSonomy bookmarks for /concept/tag/postgreshttps://www.bibsonomy.org/concept/tag/postgresBibSonomy RSS Feed for /concept/tag/postgresHow to Determine Your Postgres Version | AtlassianSELECT version();
https://www.atlassian.com/data/admin/how-to-view-which-postgres-version-is-runningjil2024-11-13T17:14:10+01:00version select sql postgres <span itemprop="description">SELECT version();
</span>What I Wish Someone Told Me About Postgres | ChallahScripthttps://challahscript.com/what_i_wish_someone_told_me_about_postgresbshanks2024-11-12T04:13:49+01:00postgresql sql postgres <a itemprop="url" data-versiondate="2024-11-12T04:13:49+01:00" href="https://challahscript.com/what_i_wish_someone_told_me_about_postgres" rel="nofollow" class="description-link">https://challahscript.com/what_i_wish_someone_told_me_about_postgres</a>Postgres Partition Conversion: minimal downtimeBasically there are 4 steps:
Rename old table
Create new table
with partitioning
Add constraint on old table for it's proposed partition ranges
Attach old table as a partition to new partition table
Sounds easy right?
What about indexes? What about Triggers?
And guess what, there are other traps to watch out for!https://www.kylehailey.com/post/postgres-partition-conversion-minimal-downtimejil2024-08-21T22:58:31+02:00partition set pain pita psql convert create variable postgres script <span itemprop="description">Basically there are 4 steps:
Rename old table
Create new table
with partitioning
Add constraint on old table for it's proposed partition ranges
Attach old table as a partition to new partition table
Sounds easy right?
What about indexes? What about Triggers?
And guess what, there are other traps to watch out for!</span>A Deep Dive into Table partitioning Part 3 - Maintenance under pressure - Adyen-- Add the check constraint
alter table public.test_partition_10_25 add constraint test_partition_10_25_constraint CHECK (id >= 10 AND id <25) NOT VALID;
update pg_constraint pgc
SET convalidated = true
FROM pg_class c
WHERE
c.oid = pgc.conrelid
AND connamespace = 'public'::regnamespace::oid
AND c.relname = 'test_partition_10_25'
AND conname = 'test_partition_10_25_constraint';https://www.adyen.com/knowledge-hub/maintenance-under-pressurejil2024-08-19T16:50:21+02:00hack manually not check valid update constraint force validate table postgres <span itemprop="description">-- Add the check constraint
alter table public.test_partition_10_25 add constraint test_partition_10_25_constraint CHECK (id >= 10 AND id <25) NOT VALID;
update pg_constraint pgc
SET convalidated = true
FROM pg_class c
WHERE
c.oid = pgc.conrelid
AND connamespace = 'public'::regnamespace::oid
AND c.relname = 'test_partition_10_25'
AND conname = 'test_partition_10_25_constraint';</span>Upgrade your postgreSQL Database from 14 to 15 on Debian - Unix & Linux Stack Exchangehttps://unix.stackexchange.com/questions/735327/upgrade-your-postgresql-database-from-14-to-15-on-debianjil2024-07-29T13:57:06+02:00debian update postgres <a itemprop="url" data-versiondate="2024-07-29T13:57:06+02:00" href="https://unix.stackexchange.com/questions/735327/upgrade-your-postgresql-database-from-14-to-15-on-debian" rel="nofollow" class="description-link">https://unix.stackexchange.com/questions/735327/upgrade-your-postgresql-database-from-14-to-15-on-debian</a>Maciej Walkowiak | PostgreSQL and UUID as primary keyhttps://maciejwalkowiak.com/blog/postgres-uuid-primary-key/bshanks2024-07-08T01:03:34+02:00postgresql uuid db primarykey postgres <a itemprop="url" data-versiondate="2024-07-08T01:03:34+02:00" href="https://maciejwalkowiak.com/blog/postgres-uuid-primary-key/" rel="nofollow" class="description-link">https://maciejwalkowiak.com/blog/postgres-uuid-primary-key/</a>Neon: A New Approach to Database Development - Neonhttps://neon.tech/blog/neon-gabshanks2024-04-16T18:12:02+02:00postgres <a itemprop="url" data-versiondate="2024-04-16T18:12:02+02:00" href="https://neon.tech/blog/neon-ga" rel="nofollow" class="description-link">https://neon.tech/blog/neon-ga</a>Neon Serverless Postgres is generally available | Hacker Newshttps://news.ycombinator.com/item?id=40040593bshanks2024-04-16T18:11:53+02:00postgres <a itemprop="url" data-versiondate="2024-04-16T18:11:53+02:00" href="https://news.ycombinator.com/item?id=40040593" rel="nofollow" class="description-link">https://news.ycombinator.com/item?id=40040593</a>Distributed SQLite: Paradigm shift or hype? | Hacker Newshttps://news.ycombinator.com/item?id=39975596bshanks2024-04-16T03:08:43+02:00sqlite postgres <a itemprop="url" data-versiondate="2024-04-16T03:08:43+02:00" href="https://news.ycombinator.com/item?id=39975596" rel="nofollow" class="description-link">https://news.ycombinator.com/item?id=39975596</a>ParadeDB - Postgres for Search and Analyticshttps://www.paradedb.com/bshanks2024-04-14T22:00:26+02:00db olap postgres <a itemprop="url" data-versiondate="2024-04-14T22:00:26+02:00" href="https://www.paradedb.com/" rel="nofollow" class="description-link">https://www.paradedb.com/</a>Using Clickhouse to scale an events engine · getlago/lago Wikihttps://github.com/getlago/lago/wiki/Using-Clickhouse-to-scale-an-events-enginebshanks2024-04-14T21:53:21+02:00clickhouse column db olap postgres <a itemprop="url" data-versiondate="2024-04-14T21:53:21+02:00" href="https://github.com/getlago/lago/wiki/Using-Clickhouse-to-scale-an-events-engine" rel="nofollow" class="description-link">https://github.com/getlago/lago/wiki/Using-Clickhouse-to-scale-an-events-engine</a>Hydra - Fast Postgres Analytics ++https://www.hydra.so/bshanks2024-04-14T21:53:12+02:00column db olap postgres <a itemprop="url" data-versiondate="2024-04-14T21:53:12+02:00" href="https://www.hydra.so/" rel="nofollow" class="description-link">https://www.hydra.so/</a>supabase/index_advisor: PostgreSQL Index AdvisorPostgreSQLhttps://github.com/supabase/index_advisorbshanks2024-04-14T19:29:44+02:00PostgreSQL Postgres <span itemprop="description">PostgreSQL</span>stackframe-projects/pgmock: In-memory Postgres for unit/E2E testshttps://github.com/stackframe-projects/pgmockbshanks2024-04-08T16:40:07+02:00postgres <a itemprop="url" data-versiondate="2024-04-08T16:40:07+02:00" href="https://github.com/stackframe-projects/pgmock" rel="nofollow" class="description-link">https://github.com/stackframe-projects/pgmock</a>electric-sql/pglite: Lightweight Postgres packaged as WASM into a TypeScript library for the browser, Node.js, Bun and DenoPostgreshttps://github.com/electric-sql/pglitebshanks2024-02-26T22:17:11+01:00wasm Postgres <span itemprop="description">Postgres</span>My Notes on GitLab Postgres Schema Design – Shekhar Gulatihttps://shekhargulati.com/2022/07/08/my-notes-on-gitlabs-postgres-schema-design/bshanks2024-02-25T01:41:05+01:00schema gitlab sql db postgres <a itemprop="url" data-versiondate="2024-02-25T01:41:05+01:00" href="https://shekhargulati.com/2022/07/08/my-notes-on-gitlabs-postgres-schema-design/" rel="nofollow" class="description-link">https://shekhargulati.com/2022/07/08/my-notes-on-gitlabs-postgres-schema-design/</a>GitHub - dimitri/pgloader: Migrate to PostgreSQL in a single command!pgloader will keep a separate file of rejected data, but continue trying to copy good data in your database.
pgloader also implements data reformatting, a typical example of that being the transformation of MySQL datestamps 0000-00-00 and 0000-00-00 00:00:00 to PostgreSQL NULL valuehttps://github.com/dimitri/pgloaderjil2024-01-29T11:25:18+01:00tool import copy postgres <span itemprop="description">pgloader will keep a separate file of rejected data, but continue trying to copy good data in your database.
pgloader also implements data reformatting, a typical example of that being the transformation of MySQL datestamps 0000-00-00 and 0000-00-00 00:00:00 to PostgreSQL NULL value</span>exclusion constraints: Beyond UNIQUE | PostgreSQL - CYBERTEChttps://www.cybertec-postgresql.com/en/postgresql-exclusion-constraints-beyond-unique/jil2024-01-23T15:19:03+01:00custom unique function exclude postgres <a itemprop="url" data-versiondate="2024-01-23T15:19:03+01:00" href="https://www.cybertec-postgresql.com/en/postgresql-exclusion-constraints-beyond-unique/" rel="nofollow" class="description-link">https://www.cybertec-postgresql.com/en/postgresql-exclusion-constraints-beyond-unique/</a>An overview of distributed Postgres architectures | Hacker Newshttps://news.ycombinator.com/item?id=38914764bshanks2024-01-20T23:57:28+01:00ha db postgres <a itemprop="url" data-versiondate="2024-01-20T23:57:28+01:00" href="https://news.ycombinator.com/item?id=38914764" rel="nofollow" class="description-link">https://news.ycombinator.com/item?id=38914764</a>GitHub - pgvector/pgvector: Open-source vector similarity search for Postgreshttps://github.com/pgvector/pgvector#getting-startedjil2023-11-24T16:41:29+01:00extension postgresql pgvector store vector postgres <a itemprop="url" data-versiondate="2023-11-24T16:41:29+01:00" href="https://github.com/pgvector/pgvector#getting-started" rel="nofollow" class="description-link">https://github.com/pgvector/pgvector#getting-started</a>