hunleyd, 2 days ago to PostgreSQL

“But how much does a #PostgreSQL license actually cost?” A Frequently Asked Question from #Oracle users considering PostgreSQL - Stormatics https://stormatics.tech/blogs/how-much-does-a-postgresql-license-cost

hunleyd, 2 days ago to PostgreSQL

#PostgreSQL: Why true Open Source matters https://www.cybertec-postgresql.com/en/postgresql-why-true-open-source-matters/

ascherbaum, 2 days ago to PostgreSQL

#PostgreSQL Event Calendar, Reminder:

👫 2. PostgreSQL User Group NRW MeetUp

Date: 2024-05-15T14:45:00Z - 2024-05-15T18:00:00Z
Location: digitalHUB Aachen e.V. in DIGITAL CHURCH, Jülicher Str. 72a, 52070 Aachen

ICS file: https://ics.postgresql.life/600vthak7249ocn2dehhc5s8b8.ics

marcel_jomasoft, 2 days ago to programming German

Updated PostgreSQL IPS packages for Solaris 11.4 SPARC are available
Versions 16.3, 15.7, 14.12, 13.15, 12.19

https://www.jomasoft.ch/downloads/#js-opensource

#solaris #oraclesolaris #postgres #postgresql

hunleyd, 3 days ago to PostgreSQL

#PostgreSQL 16.3, 15.7, 14.12, 13.15, and 12.19 Released! https://www.postgresql.org/about/news/postgresql-163-157-1412-1315-and-1219-released-2858/

hunleyd, 3 days ago to PostgreSQL

PGXN creator David Wheeler joins Tembo to strengthen #PostgreSQL extension ecosystem | Tembo https://tembo.io/blog/welcoming-david-wheeler

ascherbaum, 3 days ago to PostgreSQL

#PostgreSQL Event Calendar, Reminder:

👫 Meetup OSDI Amsterdam

Date: 2024-05-15T16:00:00Z - 2024-05-15T19:00:00Z

ICS file: https://ics.postgresql.life/3cbq2rc9iod4hfk56ieo8bnb0n.ics

stevenharman, 4 days ago to PostgreSQL

Speaking of the #Heroku Roadmap, it would be fantastic if we could get the pg_repack #postgresql extension added! Show your support! https://github.com/heroku/roadmap/issues/123

hunleyd, 4 days ago to PostgreSQL

Waiting for #PostgreSQL 17 – In plpgsql, allow %TYPE and %ROWTYPE to be followed by array decoration. – select * from depesz; https://www.depesz.com/2024/01/22/waiting-for-postgresql-17-in-plpgsql-allow-type-and-rowtype-to-be-followed-by-array-decoration/

hunleyd, 4 days ago to PostgreSQL

How to use #PostgreSQL® SUBSTRING https://dev.to/ftisiot/how-to-use-postgresqlr-substring-1mon

ascherbaum, 4 days ago to PostgreSQL

New entry in #PostgreSQL Event Calendar:

👫 Hamburg PostgreSQL User Group

Date: 2024-04-23T16:30:00Z - 2024-04-23T18:30:00Z
Location: DER SPIEGEL, Ericusspitze 1, 20457 Hamburg, Deutschland

ICS file: https://ics.postgresql.life/k930tmtkn19g8fl6t6j3iprebodipk660u4vce5basgcmm7k1vneuq16vs.ics

ascherbaum, 4 days ago to PostgreSQL

On this day, 24 years ago, #PostgreSQL v7.0 was released.

This release brings Foreign Keys, SQL92 Join syntax (although not all join types) and unlimited query length.

Ever seen the occasional 2 MB long query? That version made it possible.

kta, 5 days 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, 5 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, 5 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, 6 days ago to PostgreSQL

PostgreSQL Person of the Week interview with: Nazir Bilal Yavuz

#PostgreSQL #Interview

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

ascherbaum, 6 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, 9 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, 9 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, 9 days ago to PostgreSQL

Lesser Known #PostgreSQL Features

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

hunleyd, 10 days ago to PostgreSQL

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

hunleyd, 10 days ago to PostgreSQL

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

ErikUden, 4 months ago (edited 4 months ago) to random

Eine E-Mail. 40.000 Accounts gerettet. Was ein Tag. ✉️ #SaveTroetCafe