hunleyd, to PostgreSQL
@hunleyd@fosstodon.org avatar
ascherbaum, to PostgreSQL
@ascherbaum@mastodon.social avatar

New entry in #PostgreSQL Event Calendar:

👫 Prague PostgreSQL Meetup

Date: 2024-04-29T16:00:00Z - 2024-04-29T18:00:00Z
Location: Betsys
Karolinská 650/1, 186 00 Karlín, Tschechien

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

vyruss, to chicago
@vyruss@fosstodon.org avatar
hunleyd, to PostgreSQL
@hunleyd@fosstodon.org avatar

A Comprehensive Overview of #PostgreSQL Query Processing Stages - Highgo Software Inc. https://www.highgo.ca/2024/01/26/a-comprehensive-overview-of-postgresql-query-processing-stages/

hunleyd, to PostgreSQL
@hunleyd@fosstodon.org avatar

What’s ‘Rows Removed By Filter’ in #PostgreSQL Query Plans all about? https://andyatkinson.com/blog/2024/01/25/PostgreSQL-rows-removed-by-filter-meaning

ascherbaum, to PostgreSQL
@ascherbaum@mastodon.social avatar

#PostgreSQL Event Calendar, Reminder:

👫 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, to PostgreSQL
@ascherbaum@mastodon.social avatar

Schedule for the is available. Get your ticket now!

https://www.pgday.ch/2024/

ascherbaum, to PostgreSQL
@ascherbaum@mastodon.social avatar

PostgreSQL Person of the Week interview with: Philip Marks

#PostgreSQL #Interview

https://postgresql.life/post/philip_marks/

ascherbaum, to PostgreSQL
@ascherbaum@mastodon.social avatar

#PostgreSQL Event Calendar, Reminder:

🌐 Metadata for All: Enabling discovery, packaging, and community

Date: 2024-05-15T17:00:00Z - 2024-05-15T18:00:00Z
Location: online

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

clairegiordano, to PostgreSQL
@clairegiordano@hachyderm.io avatar

Hello to those of you who went to #PGDayChicago (organized by the amazing Henrietta Dombrovskaya) here are my slides.

The conference was so much fun! 🎉🐘 I was honored to give this talk & spend time w/#PostgreSQL & #Microsoft friends

🎤 Map of Amazing Postgres Extensions You Might Not Know About 🎤

#Postgres #OpenSource #database #conference

https://speakerdeck.com/clairegiordano/map-of-amazing-postgres-extensions-you-might-not-know-about-claire-giordano-pgday-chicago-2024

hunleyd, to PostgreSQL
@hunleyd@fosstodon.org avatar

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

hunleyd, to PostgreSQL
@hunleyd@fosstodon.org avatar
ascherbaum, to PostgreSQL
@ascherbaum@mastodon.social avatar

#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, to programming German
@marcel_jomasoft@mastodon.world avatar

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, to PostgreSQL
@hunleyd@fosstodon.org avatar
hunleyd, to PostgreSQL
@hunleyd@fosstodon.org avatar

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

ascherbaum, to PostgreSQL
@ascherbaum@mastodon.social avatar

#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, to PostgreSQL
@stevenharman@ruby.social avatar

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

hunleyd, to PostgreSQL
@hunleyd@fosstodon.org avatar

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, to PostgreSQL
@hunleyd@fosstodon.org avatar
ascherbaum, to PostgreSQL
@ascherbaum@mastodon.social avatar

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, to PostgreSQL
@ascherbaum@mastodon.social avatar

On this day, 24 years ago, 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, to PostgreSQL
@kta@hostux.social avatar

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/

kta,
@kta@hostux.social avatar

Any pointers on ZFS for databases out in the wild? A favorite configuration to consider?

ferki,
@ferki@fosstodon.org avatar

@kta I've found the following an interesting read a while back on the performance and robustness considerations of running #PostgreSQL on #ZFS:

https://vadosware.io/post/everything-ive-seen-on-optimizing-postgres-on-zfs-on-linux/

Happy hacking!

ErikUden, (edited ) to random
@ErikUden@mastodon.de avatar

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

db_geek,
@db_geek@norden.social avatar

@jens Eventuell bezieht Erik sich auf diesen offenen Issue bei #Mastodon.
Der angegebene Link zur #PostgreSQL-Änderung nennt das Fehlerbild ziemlich genau, aber keine Lösung dafür:

In new btree indexes, the maximum index entry length is reduced by eight bytes, to improve handling of duplicate entries (Peter Geoghegan)  
This means that a REINDEX operation on an index pg_upgrade'd from a previous release could potentially fail.  

https://github.com/mastodon/mastodon/issues/18965

  • All
  • Subscribed
  • Moderated
  • Favorites
  • megavids
  • thenastyranch
  • rosin
  • GTA5RPClips
  • osvaldo12
  • love
  • Youngstown
  • slotface
  • khanakhh
  • everett
  • kavyap
  • mdbf
  • DreamBathrooms
  • ngwrru68w68
  • provamag3
  • magazineikmin
  • InstantRegret
  • normalnudes
  • tacticalgear
  • cubers
  • ethstaker
  • modclub
  • cisconetworking
  • Durango
  • anitta
  • Leos
  • tester
  • JUstTest
  • All magazines