kta, 1 month ago to PostgreSQL

In #postgresql database land today. Thinking through striping and mirroring on #ZFS. Klara Systems has unpacked a lot of this:

... This means two things: solid state and mirrors. SSD drives provide far lower latency than conventional drives possibly can. And mirrors provide far better random access performance than RAIDz can—particularly when we’re talking about small random access ops, which can’t be effectively spread across tons of disks in a wide striped vdev...

[1] https://klarasystems.com/articles/openzfs-storage-best-practices-and-use-cases-part-3-databases-and-vms/

hunleyd, 1 month 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, 1 month 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, 1 month ago to PostgreSQL

PostgreSQL Person of the Week interview with: Nazir Bilal Yavuz

#PostgreSQL #Interview

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

ascherbaum, 1 month 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, 1 month 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, 1 month 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, 1 month ago to PostgreSQL

Lesser Known #PostgreSQL Features

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

hunleyd, 1 month ago to PostgreSQL

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

hunleyd, 1 month ago to PostgreSQL

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

ascherbaum, 1 month 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, 1 month ago to PostgreSQL

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

kevinbrill, 1 month 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, 1 month 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, 1 month 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, 1 month 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, 1 month 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, 1 month 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, 1 month 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, 1 month ago to PostgreSQL

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

ascherbaum, 1 month 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, 1 month 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, 1 month 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, 1 month 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, 1 month 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. 💥