pg_dwc's profile picture. PostgreSQL, music, math

David Christensen

@pg_dwc

PostgreSQL, music, math

David Christensen hat repostet

When you're married to a Postgres person and you share everything - including a job, a house, and a bunch of kids ... pretty sure GROUP BY ALL is the ultimate SQL patch to represent that. ❤️ 🐘


David Christensen hat repostet

Let’s talk about Postgres scan types. Most of us have been in EXPLAIN and read some plans. Here’s some details about the different scan types and a diagram for thinking about how they work. ❖ Sequential scan: reads the entire table, row by row checking to see what matches the…

crunchydata's tweet image. Let’s talk about Postgres scan types. Most of us have been in EXPLAIN and read some plans. Here’s some details about the different scan types and a diagram for thinking about how they work. 

❖ Sequential scan: reads the entire table, row by row checking to see what matches the…

Hoping that showing up at an antique mall with my wife and a U-Haul does not rate as one of 2025’s worst mistakes.


Really excited to have worked on this; we really hide the complexity involved with some cool functionality for a truly seamless experience.

Today we're announcing the availability of logical replication from Postgres to Iceberg with Crunchy Data Warehouse. Now you can seamlessly move data and stream changes from your operational database into an analytical system. crunchydata.com/blog/logical-r…



Looking forward to discussing my favorite database software and security concepts in particular. I’ve seen the development of @sqlliz ‘s talk here and you won’t want to miss it!

KC friends 📣 I'll be giving a talk at the Kansas City Postgres Meetup this week on Thursday night about Postgres Security. @pg_dwc will be there too! Join us. meetup.com/kansas-city-po…

sqlliz's tweet image. KC friends 📣 I'll be giving a talk at the Kansas City Postgres Meetup this week on Thursday night about Postgres Security. @pg_dwc will be there too!  Join us. meetup.com/kansas-city-po…


David Christensen hat repostet

\conninfo is a command in psql for showing your current connection details. If multiple terminal windows and databases are open, you can check connection details without logging out and back in. \conninfo will display: -database name -username -host and port of the database…

crunchydata's tweet image. \conninfo is a command in psql for showing your current connection details. If multiple  terminal windows and databases are open, you can check connection details without logging out and back in.

\conninfo will display:
-database name
-username
-host and port of the database…

Craig really highlights some of the really interesting work we've been doing here at Crunchy Data. It is hard to make complex things simple and I think we've done a good job here at making things Just Work™ in as natural a Postgres experience as possible.

Multiple times a week I'm having conversations with people that have built overly complex data pipelines. What used to just work is now a team of people gluing and duct taping solutions together with the latest shiny data engineering tools. When I initially showed some of what…

craigkerstiens's tweet image. Multiple times a week I'm having conversations with people that have built overly complex data pipelines. What used to just work is now a team of people gluing and duct taping solutions together with the latest shiny data engineering tools. 

When I initially showed some of what…


I think my first computer I got back in the late 1900’s was around that price point but for a 60 mhz Power Mac 6100/60. I hesitate to do the math there on either the specs or inflation!

I do not get how laptops have had like 0 inflation in 30 years. My dad bought me my first laptop in '97 and it was $3,000. ChatGPT just told me my new Apple m4 is 375 times more powerful than a '97 dell - 14-Core CPU - 20-Core GPU - 24GB Memory - 1TB SSD $2,399 ... like how?



David Christensen hat repostet

David Christensen (@pg_dwc): Building PostgreSQL Extensions: Dropping Extensions and Cleanup postgr.es/p/6sR


David Christensen hat repostet

Elizabeth Garrett Christensen (@sqlliz): Contributing to Postgres 101: A Beginner's Experience postgr.es/p/6sl


There's still time to join the open PostgreSQL Extensions Exosystem Mini-Summit, starting in 1 hour: eventbrite.com/x/postgres-ext…


David Christensen hat repostet

Kansas City Postgres meetup on Monday at 5 at the Lenexa library. Talking about CDC pipelines and logical replication with David Christensen (@pg_dwc) meetup.com/kansas-city-po…


David Christensen hat repostet

I've joined the Board of The United States PostgreSQL Association @pgus 🥳🐘. Our mission of education in PostgreSQL is something I care a lot about. If you have thoughts on Postgres events, education, diversity, or any of our initiatives, reach out anytime.


Loading...

Something went wrong.


Something went wrong.