PostgreSQL

651 readers
1 users here now

The world's most advanced open source relational database

Project
Events
Podcasts
Related Fediverse communities

founded 1 year ago
MODERATORS
Ategon
starman
jnovinger
listing: all - local
1
23
PostgreSQL 16.3, 15.7, 14.12, 13.15, and 12.19 Released! (www.postgresql.org)
submitted 5 months ago by mac to c/postgresql
0 comments fedilink
2
4
How not to change PostgreSQL column type | boringSQL (notso.boringsql.com)
submitted 1 month ago by jnovinger to c/postgresql
0 comments fedilink
 
 

Via https://fosstodon.org/@hunleyd/113205392466307810

3
15
PostgreSQL 17 Released! (www.postgresql.org)
submitted 1 month ago by [email protected] to c/postgresql
0 comments fedilink
4
5
Improved query cancellation in PostgreSQL 17 and Psycopg 3.2 (blog.dalibo.com)
submitted 1 month ago by jnovinger to c/postgresql
1 comments fedilink
 
 

Via https://fosstodon.org/@hunleyd/113080821469886930

5
12
Adding a Primary Key To An Existing Table [via RoR] (www.stevenan.com)
submitted 3 months ago* (last edited 3 months ago) by jnovinger to c/postgresql
1 comments fedilink
 
 

Via https://mastodon.social/@stevenan/112899205276153700

6
14
GitHub - supabase/pg_jsonschema: PostgreSQL extension providing JSON Schema validation (github.com)
submitted 6 months ago by lysdexic to c/postgresql
0 comments fedilink
7
6
POSETTE: An Event for Postgres 2024 | 3rd annual virtual event organized by the Postgres team at Microsoft | 48 Hours of Virtual Presentations and Meetings Starting Tue, June 11 @ 3:00 PM UTC (www.citusdata.com)
submitted 6 months ago by ericjmorey to c/postgresql
0 comments fedilink
8
19
PostgreSQL Lands Support For Incremental Backups (www.phoronix.com)
submitted 7 months ago by jnovinger to c/postgresql
1 comments fedilink
 
 

Via https://mastodon.social/@[email protected]/112220150255942506

9
6
GitHub - tatut/pgprolog: PostgreSQL Prolog language handler (github.com)
submitted 7 months ago by [email protected] to c/postgresql
0 comments fedilink
 
 

Prolog language for PostgreSQL

This is a PostgreSQL extension that allows writing stored procedures in Prolog.

This embeds Scryer Prolog into a PostgreSQL extension.

Proof of concept! Not ready for any actual use.

10
76
PostgreSQL maintainer Simon Riggs has died in a small airplane crash (m6n.io)
submitted 7 months ago by [email protected] to c/postgresql
1 comments fedilink
 
 

PostgreSQL maintainer Simon Riggs has died in a small airplane crash, on Tuesday.

For those who didn't know Simon, he's responsible for PostgreSQL Binary Replication and many big data features. He and I worked together at Greenplum 2006-2008. Postgres would not be the world-leading DB it is today if it weren't for him.

https://www.bbc.com/news/articles/cjex992z0wlo

11
11
Recovering Deleted Data From PostgreSQL Tables (www.cybertec-postgresql.com)
submitted 7 months ago by mac to c/postgresql
0 comments fedilink
12
7
Introducing pgzx: create PostgreSQL extensions using Zig (xata.io)
submitted 7 months ago by mac to c/postgresql
0 comments fedilink
13
6
Will PostgreSQL ever change its license? | Jonathan Katz (jkatz05.com)
submitted 7 months ago by mac to c/postgresql
0 comments fedilink
14
8
PGConf NYC 2024 - Call for Presentations (CFP) and Sponsors! (www.postgresql.org)
submitted 7 months ago by mac to c/postgresql
0 comments fedilink
15
11
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 7 months ago by mac to c/postgresql
0 comments fedilink
16
32
Request for SQL experts: Lemmy PR to combine action tables (github.com)
submitted 8 months ago by [email protected] to c/postgresql
13 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?

17
11
What’s new in the Postgres 16 query planner / optimizer (www.citusdata.com)
submitted 8 months ago by mac to c/postgresql
0 comments fedilink
18
4
Is it possible to upgrade PostreSQL from 14 to 16 directly when using containers? (social.touha.me)
submitted 8 months ago* (last edited 8 months ago) by [email protected] to c/postgresql
1 comments fedilink
 
 

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

19
9
UUID Benchmark War (ardentperf.com)
submitted 8 months ago by agilob to c/postgresql
0 comments fedilink
20
8
The performance cost of pl/pgsql exception block in Postgres (dev.to)
submitted 9 months ago by Serpent7776 to c/postgresql
0 comments fedilink
21
27
“But how much does a PostgreSQL license actually cost?” A Frequently Asked Question from Oracle users considering PostgreSQL (stormatics.tech)
submitted 9 months ago by jnovinger to c/postgresql
3 comments fedilink
22
8
One PID to Lock Them All: Finding the Source of the Lock in Postgres (www.crunchydata.com)
submitted 9 months ago by mac to c/postgresql
0 comments fedilink
23
9
Prague PostgreSQL Developer Day 2024 / Call for Papers & Sponsors (www.postgresql.org)
submitted 9 months ago by mac to c/postgresql
0 comments fedilink
24
19
How we migrated our PostgreSQL database with 11 seconds downtime - Government Digital Service (gds.blog.gov.uk)
submitted 9 months ago* (last edited 9 months ago) by starman to c/postgresql
2 comments fedilink
25
5
Waiting for Postgres 17: Incremental base backups (pganalyze.com)
submitted 9 months ago by starman to c/postgresql
1 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.

view more: next ›