listing: all - local
76
1
PGConf NYC 2024 - Call for Presentations (CFP) and Sponsors! (www.postgresql.org)
submitted 2 years ago by to c/postgresql@programming.dev
comment fedilink
77
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 to c/postgresql@programming.dev
comment fedilink
78
1
Request for SQL experts: Lemmy PR to combine action tables (github.com)
submitted 2 years ago by to c/postgresql@programming.dev
2 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?

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

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

81
1
UUID Benchmark War (ardentperf.com)
submitted 2 years ago by to c/postgresql@programming.dev
comment fedilink
82
2
The performance cost of pl/pgsql exception block in Postgres (dev.to)
submitted 2 years ago by to c/postgresql@programming.dev
comment fedilink
83
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 [M] to c/postgresql@programming.dev
3 comments fedilink
84
1
One PID to Lock Them All: Finding the Source of the Lock in Postgres (www.crunchydata.com)
submitted 2 years ago by to c/postgresql@programming.dev
comment fedilink
85
1
Prague PostgreSQL Developer Day 2024 / Call for Papers & Sponsors (www.postgresql.org)
submitted 2 years ago by to c/postgresql@programming.dev
comment fedilink
86
1
How we migrated our PostgreSQL database with 11 seconds downtime - Government Digital Service (gds.blog.gov.uk)
submitted 2 years ago* by [M] to c/postgresql@programming.dev
comment fedilink
87
1
Waiting for Postgres 17: Incremental base backups (pganalyze.com)
submitted 2 years ago by [M] to c/postgresql@programming.dev
comment 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.

88
1
Don't Do This - PostgreSQL wiki (wiki.postgresql.org)
submitted 2 years ago by [M] to c/postgresql@programming.dev
comment fedilink
89
1
Nine ways to shoot yourself in the foot with PostgreSQL (philbooth.me)
submitted 2 years ago by [M] to c/postgresql@programming.dev
comment fedilink
90
1
Query Exercise: Find Posts with the Wrong CommentCount (smartpostgres.com)
submitted 2 years ago by [M] to c/postgresql@programming.dev
comment 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"

91
2
PostgreSQL is the DBMS of the Year for 2023 (db-engines.com)
submitted 2 years ago* by to c/postgresql@programming.dev
comment fedilink
92
1
Waiting for PostgreSQL 17 – Add support for incremental backup. – select * from depesz; (www.depesz.com)
submitted 2 years ago by to c/postgresql@programming.dev
comment fedilink
93
1
How to setup TLS connection for PostgreSQL (postgr.es)
submitted 2 years ago by to c/postgresql@programming.dev
comment fedilink
94
1
AI Meets PostgreSQL - The pgvector Revolution in Text Search - Stormatics (postgr.es)
submitted 2 years ago by to c/postgresql@programming.dev
comment fedilink
95
1
PostgreSQL: Full text search with the “websearch” syntax (adamj.eu)
submitted 2 years ago by to c/postgresql@programming.dev
comment fedilink
 
 

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

96
1
An Introduction to EDB's Transparent Data Encryption - Stormatics (stormatics.tech)
submitted 2 years ago by [M] to c/postgresql@programming.dev
comment fedilink
97
1
2023 State of PostgreSQL Survey Results (www.timescale.com)
submitted 2 years ago by to c/postgresql@programming.dev
comment fedilink
98
1
Functions to Validate User's Input (fluca1978.github.io)
submitted 2 years ago by [M] to c/postgresql@programming.dev
comment fedilink
99
1
Postgres Language Server: implementing the Parser (supabase.com)
submitted 2 years ago by [M] to c/postgresql@programming.dev
comment fedilink
 
 

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

100
1
Transaction Isolation in Postgres, explained (www.thenile.dev)
submitted 2 years ago by to c/postgresql@programming.dev
comment fedilink
view more: ‹ prev next ›