hunleyd, 16 days ago to PostgreSQL

Understanding Hash aggregates and Hash Joins in #PostgreSQL - Stormatics https://stormatics.tech/alis-planet-postgresql/understanding-hash-aggregates-and-hash-joins-in-postgresql

ascherbaum, 16 days ago to PostgreSQL

Updated entry in #PostgreSQL Event Calendar:

🌐 San Francisco Bay Area PostgreSQL Meetup Group

Date: 2024-04-10T19:30:00Z - 2024-04-10T20:30:00Z
Location: Online

ICS file: https://ics.postgresql.life/6anml8omn3u9c5sfnlomev6ag8.ics

ascherbaum, 17 days ago to PostgreSQL

PostgreSQL Person of the Week interview with: Nazir Bilal Yavuz

#PostgreSQL #Interview

https://postgresql.life/post/nazir_bilal_yavuz/

ascherbaum, 17 days ago to PostgreSQL

New entry in #PostgreSQL Event Calendar:

🌐 Path To Citus Con: Episode 14

Date: 2024-04-03T17:00:00Z - 2024-04-03T18:15:00Z
Location: https://aka.ms/open-source-discord

ICS file: https://ics.postgresql.life/6pi4ashfcntji2sg6big1ctuv2.ics

hunleyd, 19 days ago to PostgreSQL

Parallel query in #PostgreSQL with #JDBC and DBeaver- CYBERTEC https://www.cybertec-postgresql.com/en/parallel-query-postgresql-problems-jdbc-dbeaver/

ascherbaum, 20 days ago to PostgreSQL

New entry in #PostgreSQL Event Calendar:

👫 Kansas City PostgreSQL User Group

Date: 2024-06-25T23:00:00Z - 2024-06-26T00:30:00Z
Location: Johnson County Library - Lenexa City Center, 8778 Penrose Ln, Lenexa, KS 66219, United States

ICS file: https://ics.postgresql.life/472fj41hgj0g1jobp402e703u7.ics

frankel, 20 days ago to PostgreSQL

Lesser Known #PostgreSQL Features

https://hakibenita.com/postgresql-unknown-features

hunleyd, 20 days ago to PostgreSQL

Installing PL/Java on #PostgreSQL 16 and Rocky Linux https://fluca1978.github.io/2024/01/17/pljavaPostgreSQL16.html

hunleyd, 21 days ago to PostgreSQL

How to speed up COUNT(DISTINCT) | EverSQL #postgresql https://www.eversql.com/how-to-speed-up-countdistinct/

ascherbaum, 21 days ago to PostgreSQL

#PostgreSQL Event Calendar, Reminder:

👫 Kansas City PostgreSQL User Group

Date: 2024-05-08T23:00:00Z - 2024-05-09T00:00:00Z
Location: Johnson County Library - Lenexa City Center, 8778 Penrose Ln, Lenexa, KS 66219, United States

ICS file: https://ics.postgresql.life/49gthst4lksjmk7evk3uu97u3e.ics

hunleyd, 21 days ago to PostgreSQL

Optimizing #PostgreSQL functions with preloaded libraries https://www.cybertec-postgresql.com/en/optimizing-postgresql-functions-with-preloaded-libraries/

kevinbrill, 22 days ago to PostgreSQL

sigh The #postgresql logical replication process that has been running for around 3 weeks failed upon completion last night.

ERROR: table copy could not finish transaction on publisher: FATAL: terminating connection due to idle-in-transaction timeout
SSL connection has been closed unexpectedly

Time for google I suppose and an email to our on-retainer postgres expert.

Moving billions of records from one database to another is a PITA yo.

ascherbaum, 22 days ago to PostgreSQL

#PostgreSQL Event Calendar, Reminder:

👫 PGDay Belgium 2024

Date: 2024-05-07
Location: Leuven, Belgium

ICS file: https://ics.postgresql.life/7k59dmrditgg6q63mpicqvs0t2.ics

hunleyd, 22 days ago to PostgreSQL

#JSON in #PostgreSQL: Revolutionizing Data Flexibility in Your Database - Highgo Software Inc. https://www.highgo.ca/2024/01/15/json-in-postgresql-revolutionizing-data-flexibility-in-your-database/

paulox, 23 days ago to PostgreSQL

I'll be speaking at Posette, formerly Citus Con, a free and virtual developer conference on June 11-13, 2024 organized by PostgreSQL team at Microsoft 🐘
Save the date! 📅

CC @posetteconf

https://citusdata.com/posette/2024

#PosetteConf #CitusCon #PostgreSQL #Python #Django #SemanticSearch

hunleyd, 23 days ago to PostgreSQL

#PostgreSQL Added as CVE Numbering Authority (CNA) https://www.cve.org/Media/News/item/news/2024/01/16/PostgreSQL-Added-as-CNA

ascherbaum, 23 days ago to PostgreSQL

New entry in #PostgreSQL Event Calendar:

👫 Kansas City PostgreSQL User Group

Date: 2024-05-08T23:00:00Z - 2024-05-09T00:00:00Z
Location: Johnson County Library - Lenexa City Center, 8778 Penrose Ln, Lenexa, KS 66219, United States

ICS file: https://ics.postgresql.life/49gthst4lksjmk7evk3uu97u3e.ics

hunleyd, 23 days ago to PostgreSQL

Waiting for #PostgreSQL 17 – ALTER TABLE command to change generation expression – select * from depesz; https://www.depesz.com/2024/01/15/waiting-for-postgresql-17-alter-table-command-to-change-generation-expression/

hunleyd, 24 days ago to PostgreSQL

#PostgreSQL 17: part 3 or CommitFest 2023-11 https://postgrespro.com/blog/pgsql/5970508

ascherbaum, 24 days ago to hamburg

#Hamburg #PostgreSQL #Meetup in April 2024

At #DerSpiegel

https://andreas.scherbaum.la/post/2024-04-29_hamburg-postgresql-meetup-in-april-2024/

ascherbaum, 24 days ago to PostgreSQL

#PostgreSQL Event Calendar, Reminder:

👫 PDXPUG - Portland PostgreSQL Users Group Meetup

Date: 2024-04-19T01:30:00Z - 2024-04-19T03:30:00Z

ICS file: https://ics.postgresql.life/273pm9m8s5v7h1aeu13qu0sqpn.ics

wilson, 24 days ago to golang

This weekend, I hacked together a markdown documentation generator for Postgres in Go. It should be extensible to other databases, as well as including other properties from database.

It's called SQLDoc — please check it out!

#golang #postgres #postgresql #sql

https://husin.dev/sqldoc/

Zekovski, 25 days ago to PostgreSQL French

Est-ce qu'il y a des postgresexuels qui peuvent m'aider ? Apparemment j'ai un problème dans ma base de données mais je n'y connais rien.

https://forum.funkwhale.audio/d/556-front-page-displays-errors/8

#PostgreSql #SQL #Help

benoit, 27 days ago to PostgreSQL French

Yesterday we migrated many #postgresql databases to 16.2. It went smoothly for all of them except one.
The database is used by Sidekiq for 90% of the traffic. We choose a time window outside of working hours, but still we had some traffic, and we didn't turn off pods. The database was inaccessible for 10min. Jobs rescheduled, and quickly auto-scaling was triggered. I was not able to perform ANALYZE. So requests retrying at the same time + huge disk read. 💥