PostgreSQL

1572 readers
1 users here now

The world's most advanced open source relational database

Project
Events
Podcasts
Related Fediverse communities

founded 2 years ago
MODERATORS
Ategon@programming.dev
starman@programming.dev
jnovinger@programming.dev
listing: all - local
51
1
Will PostgreSQL ever change its license? | Jonathan Katz (jkatz05.com)
submitted 2 years ago by mac@programming.dev to c/postgresql@programming.dev
0 comments fedilink
52
1
PGConf NYC 2024 - Call for Presentations (CFP) and Sponsors! (www.postgresql.org)
submitted 2 years ago by mac@programming.dev to c/postgresql@programming.dev
0 comments fedilink
53
1
PostgreSQL JDBC 42.7.3, 42.6.2, 42.5.6, 42.4.5, 42.3.10, 42.2.29 Released (www.postgresql.org)
submitted 2 years ago by mac@programming.dev to c/postgresql@programming.dev
0 comments fedilink
54
1
Request for SQL experts: Lemmy PR to combine action tables (github.com)
submitted 2 years ago by dessalines@lemmy.ml to c/postgresql@programming.dev
0 comments fedilink
 
 

Lemmy currently uses distinct tables like post_like: (post_id, person_id, score) and post_saved. Unfortunately this causes performance issues when we have to join many of these tables to create views.

One suggestion in this PR, is to combine these into a single post_action table, with a lot of optional columns depending on the action. This solution scares me a little, because I'm afraid we might lose data integrity, and many of our constraints with so many optional columns.

Is there a better way of doing this in SQL?

55
1
What’s new in the Postgres 16 query planner / optimizer (www.citusdata.com)
submitted 2 years ago by mac@programming.dev to c/postgresql@programming.dev
0 comments fedilink
56
1
Is it possible to upgrade PostreSQL from 14 to 16 directly when using containers? (social.touha.me)
submitted 2 years ago* (last edited 2 years ago) by dragnucs@social.touha.me to c/postgresql@programming.dev
0 comments fedilink
 
 

Is it possible to upgrade PostreSQL from 14 to 16 directly when using containers?
@postgresql

57
1
UUID Benchmark War (ardentperf.com)
submitted 2 years ago by agilob@programming.dev to c/postgresql@programming.dev
0 comments fedilink
58
2
The performance cost of pl/pgsql exception block in Postgres (dev.to)
submitted 2 years ago by Serpent7776@programming.dev to c/postgresql@programming.dev
0 comments fedilink
59
1
“But how much does a PostgreSQL license actually cost?” A Frequently Asked Question from Oracle users considering PostgreSQL (stormatics.tech)
submitted 2 years ago by jnovinger@programming.dev to c/postgresql@programming.dev
3 comments fedilink
60
1
One PID to Lock Them All: Finding the Source of the Lock in Postgres (www.crunchydata.com)
submitted 2 years ago by mac@programming.dev to c/postgresql@programming.dev
0 comments fedilink
61
1
Prague PostgreSQL Developer Day 2024 / Call for Papers & Sponsors (www.postgresql.org)
submitted 2 years ago by mac@programming.dev to c/postgresql@programming.dev
0 comments fedilink
62
1
How we migrated our PostgreSQL database with 11 seconds downtime - Government Digital Service (gds.blog.gov.uk)
submitted 2 years ago* (last edited 2 years ago) by starman@programming.dev to c/postgresql@programming.dev
0 comments fedilink
63
1
Waiting for Postgres 17: Incremental base backups (pganalyze.com)
submitted 2 years ago by starman@programming.dev to c/postgresql@programming.dev
0 comments fedilink
 
 

We walk through the incremental backup feature committed to the Postgres 17 development branch by Robert Haas. We show an example on our local machine.

64
1
Don't Do This - PostgreSQL wiki (wiki.postgresql.org)
submitted 2 years ago by jnovinger@programming.dev to c/postgresql@programming.dev
0 comments fedilink
65
1
Nine ways to shoot yourself in the foot with PostgreSQL (philbooth.me)
submitted 2 years ago by jnovinger@programming.dev to c/postgresql@programming.dev
0 comments fedilink
66
1
Query Exercise: Find Posts with the Wrong CommentCount (smartpostgres.com)
submitted 2 years ago by jnovinger@programming.dev to c/postgresql@programming.dev
0 comments fedilink
 
 

Via https://mstdn.social/@michristofides/111738621686733546

There's a fun looking new weekly #PostgreSQL newsletter from Brent Ozar (one of my favourite authors from the SQL Server community).

From this week's post: "But… I’m a DBA, and you know what DBA stands for: Doesn’t Believe Anyone"

67
2
PostgreSQL is the DBMS of the Year for 2023 (db-engines.com)
submitted 2 years ago* (last edited 2 years ago) by mac@programming.dev to c/postgresql@programming.dev
0 comments fedilink
68
1
Waiting for PostgreSQL 17 – Add support for incremental backup. – select * from depesz; (www.depesz.com)
submitted 2 years ago by daamien@lemmy.world to c/postgresql@programming.dev
0 comments fedilink
69
1
How to setup TLS connection for PostgreSQL (postgr.es)
submitted 2 years ago by daamien@lemmy.world to c/postgresql@programming.dev
0 comments fedilink
70
1
AI Meets PostgreSQL - The pgvector Revolution in Text Search - Stormatics (postgr.es)
submitted 2 years ago by daamien@lemmy.world to c/postgresql@programming.dev
0 comments fedilink
71
1
PostgreSQL: Full text search with the “websearch” syntax (adamj.eu)
submitted 2 years ago by norambna@programming.dev to c/postgresql@programming.dev
0 comments fedilink
 
 

via https://fosstodon.org/@adamchainz/111694569833742858

72
1
An Introduction to EDB's Transparent Data Encryption - Stormatics (stormatics.tech)
submitted 2 years ago by jnovinger@programming.dev to c/postgresql@programming.dev
0 comments fedilink
73
1
2023 State of PostgreSQL Survey Results (www.timescale.com)
submitted 2 years ago by mac@programming.dev to c/postgresql@programming.dev
0 comments fedilink
74
1
Functions to Validate User's Input (fluca1978.github.io)
submitted 2 years ago by jnovinger@programming.dev to c/postgresql@programming.dev
0 comments fedilink
75
1
Postgres Language Server: implementing the Parser (supabase.com)
submitted 2 years ago by jnovinger@programming.dev to c/postgresql@programming.dev
0 comments fedilink
 
 

Via https://botsin.space/@planetpostgresql/111602978945432365

view more: ‹ prev next ›