speaking of work, might be looking for a postgres / linux guru (scripting, ansible or similar, some python) in the next few months. Anybody looking or soon to be available? permanent role in the US, either in North Carolina or remote.

#postgres #linux #jobs

speaking of work, might be looking for a postgres / linux guru (scripting, ansible or similar, some python) in the next few months. Anybody looking or soon to be available? permanent role in the US, either in North Carolina or remote.

#postgres #linux #jobs

I have a very large Postgres database (200MB compressed dump, >1.5TB fully materialized on disk) that I want to run large analytical queries on.

Should I
- Connect with DuckDB postgres scanner (https://duckdb.org/2022/09/30/postgres-scanner)?
- Dump everything to parquet?

It has views and materialized views that I think I do want.

#postgres #DuckDB #RStats

News includes @elixirlang v1.20.0-rc.1, 2 new Elixir-native Bash interpreters, zero-boilerplate component storybooks, #DurableObject library for persistent actors, #Postgres search extension, a new #RAG approach skips vector DBs, and more! #ElixirLang https://www.youtube.com/watch?v=BzOk2CJ_JRQ

The video for our December PUG "What's New in PostgreSQL 18" with Christophe Pettus, is now available on our YouTube Channel:

https://www.youtube.com/watch?v=_ZObqoXQrD4

#PostgreSQL #postgres #meetup

The video for our December PUG "What's New in PostgreSQL 18" with Christophe Pettus, is now available on our YouTube Channel:

https://www.youtube.com/watch?v=_ZObqoXQrD4

#PostgreSQL #postgres #meetup

#PostgreSQL 18's new improvements simplify complex workflows, reduce round trips to the database, & make building modern apps more efficient than ever.

Our newest blog is focused on:
→ What's new in RETURNING clause functionality
→ Real-world use cases and performance benefits
→ How to leverage these enhancements in your applications

Perfect for devs & database architects looking to maximize PG18's capabilities.

Check it out: https://www.pgedge.com/blog/postgresql-18-returning-enhancements-a-game-changer-for-modern-applications

#PostgreSQL18 #OpenSource #Postgres

Diversity and inclusion make for a brighter community and a brighter future for everyone. Take a look at how our Diversity Committee incorporates that into our organization:

https://postgresql.us/diversity/

#PostgreSQL #postgres #diversity #inclusion

We are excited to welcome DALIBO ( @dalibo) as a Partner sponsor of pgDay Paris 2026! We could not run this event without our sponsors.

#postgres #postgresql #pgdayparis

https://2026.pgday.paris/sponsors/

#PostgreSQL 18's new improvements simplify complex workflows, reduce round trips to the database, & make building modern apps more efficient than ever.

Our newest blog is focused on:
→ What's new in RETURNING clause functionality
→ Real-world use cases and performance benefits
→ How to leverage these enhancements in your applications

Perfect for devs & database architects looking to maximize PG18's capabilities.

Check it out: https://www.pgedge.com/blog/postgresql-18-returning-enhancements-a-game-changer-for-modern-applications

#PostgreSQL18 #OpenSource #Postgres

We are excited to welcome DALIBO ( @dalibo) as a Partner sponsor of pgDay Paris 2026! We could not run this event without our sponsors.

#postgres #postgresql #pgdayparis

https://2026.pgday.paris/sponsors/

Postgres extension complements pgvector for performance and scale

https://github.com/timescale/pgvectorscale

#HackerNews #Postgres #pgvector #extension #performance #scale #database #technology

Obelisk 0.32: Cancellation, WebAPI, Postgres

https://obeli.sk/blog/announcing-obelisk-0-32/

#HackerNews #Obelisk #WebAPI #Postgres #Cancellation #TechNews

What We Learned from the Recent Mandrill Outage, https://mailchimp.com/what-we-learned-from-the-recent-mandrill-outage/.

Mailchimp encountered a database failure. This is the story of how they have fixed it.

#database #Postgres #outage #MailChimp

This is TSQLparser, a complete T-SQL parser written in Go. It's the kind of thing you use when you want to abandon Microsoft SQL Server for good (parser, lexer, and AST builder, to be exact).

And here it is, GPL 3.0 licenced, or email me if you have any other ideas:
h@ual.fi

https://github.com/ha1tch/tsqlparser

#golang #foss #tsql #mssql #mssqlserver #db #database #parser #microsoft #sql #sqlite #postgres

Another milestone for us at Icelandic Met Office 🎉

This week we launched a new site with #avalanche forecasts and conditions, including recent avalanches. A major update was required in the background, migrating to #Postgres and building the APIs and of course the website handled by our friends at Origo & Metall with maps from MapTiler

Another milestone for us at Icelandic Met Office 🎉

This week we launched a new site with #avalanche forecasts and conditions, including recent avalanches. A major update was required in the background, migrating to #Postgres and building the APIs and of course the website handled by our friends at Origo & Metall with maps from MapTiler

$50 PlanetScale Metal Is GA for Postgres

https://planetscale.com/blog/50-dollar-planetscale-metal-is-ga-for-postgres

#HackerNews #$50PlanetScaleMetal #Postgres #GA #PlanetScale #DatabaseNews

Pg_ClickHouse: A Postgres extension for querying ClickHouse

https://clickhouse.com/blog/introducing-pg_clickhouse

#HackerNews #Pg_ClickHouse #Postgres #ClickHouse #Database #Extension #Querying #Tools

This is TSQLparser, a complete T-SQL parser written in Go. It's the kind of thing you use when you want to abandon Microsoft SQL Server for good (parser, lexer, and AST builder, to be exact).

And here it is, GPL 3.0 licenced, or email me if you have any other ideas:
h@ual.fi

https://github.com/ha1tch/tsqlparser

#golang #foss #tsql #mssql #mssqlserver #db #database #parser #microsoft #sql #sqlite #postgres