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. www.crunchydata.com/blog/logical...

How long has it been since you checked your cache hit ratio? Ideally most of your frequently queried data is in the buffer cache. We recommend 98-99% in the cache for transactional workloads - analytical workloads are lower.

Postgres + Iceberg side-by-side next to the same query with a Postgres HEAP table. Half a millisecond for the optimized 🔥 . 10 seconds for the long method. www.crunchydata.com/products/war...

psql tip: find your config parameters that are not default with \dconfig. List of non-default configuration parameters:

Postgres does a good job of keeping internal statistics of your which are used to plan how queries are executed. But Postgres doesn't always know how columns are related. In this deep dive we look at hacking the statistics for improved performance

Miss our webinar on running Crunchy Data Warehouse on-premises? We cover an overview, hands on walk through with live querying our data lake to full Iceberg creation, and highlight of popular use cases for it. If you missed it don't worry we got you covered. www.youtube.com/watch?v=Vojg...

We all love pg_stat_statements but that data collects forever and can get a little stale. When should you reset it? Here are some tips from our support team.

Excited to announce Crunchy Data Warehouse is now available for Kubernetes and On-premises. Need faster analytics from Postgres? Want a native Postgres data lake experience? Learn more about how it works: www.crunchydata.com/blog/crunchy...

Working with psql directly in Postgres? These tips will help turn you into a psql power user -

Need to get data to or from Postgres and into Parquet? pg_parquet is an open source extension that makes this easy, no need for complicated ETL processes -

We talk with users every week about whether Citus is a good fit for them. While Citus is a very powerful Postgres extension it has very specific use cases where it does fit, here we break down the cases where Citus is a fit as well as when it's not -

When it comes to developer tools everyone has their favorite tips and tricks. And because we love Postgres we worked to capture many of our favorite tips and tricks for Postgres here in this collection -

Excited to announce built-in maintenance for Iceberg via Postgres. Now within Crunchy Data Warehouse we will automatically vacuum and continuously optimize your Iceberg data by compacting and cleaning up files. Dig into the details of how this works www.crunchydata.com/blog/automat...

Citus is a Postgres extension that turns it into a sharded, distributed, horizontally scalable database. With all these buzzwords, it attracts a lot of people thinking it can solve all their problems. We dig into when it is a good fit and when it isn't - www.crunchydata.com/blog/citus-t...

Happy pi day! 🥧 Postgres has a pi function: pi(); This can be used to calculate circular sizes and areas. @pwramsey.bsky.social looks at pi in PostGIS today with a blog post on circular forms on PostGIS with a proof for the CIRCLELINESTRING shape. www.crunchydata.com/blog/postgis...

SQL output can be messy. Psql options for formatting output. A handy option is \pset border 2 This will add top and bottom borders with double lines (╔, ╚, ╤, ╧, etc.). A Header row bordered with a double-line separator . Each row is separated by single lines. Each column is clearly separated.

Congratulations to the Postgres community on PostgreSQL once again being named the DBMS of the year in 2024, for the second year in a row. db-engines.com/en/blog_post...

Great to see this ability for "creating processing pipelines for append-only streams of data...We believe it is a foundational building block for building IoT applications on PostgreSQL that should be available to everyone, similar to pg_cron, pg_parquet, and pg_partman."

There are many incremental processing solutions, but they seem to never quite do what I need. I decided to build an extension that just keeps running the same command in Postgres with different parameters to do fast, reliable incremental data processing. That's pg_incremental. 1/n

We’re excited to release pg_incremental today - a new extension for automated incremental updates. pg_incremental is like a supercharged pg_cron that runs data pipelines, data syncs, rollups, imports and exports. www.crunchydata.com/blog/pg_incr...

Many big Postgres databases today use partitioning. Do you have a default partition? If not, you probably should. Default partitions are super important because they let you catch inconsistent data or bugs in your application code. www.crunchydata.com/blog/postgre...

We have been talking to customers a lot about the medallion architecture with data. This is a pattern we see for data lakehouses.

@crunchydata.com is up to more cool things with Postgres www.crunchydata.com/blog/crunchy...

Did you miss PostGIS day this year? If you did don't worry, you don't have to entirely miss out, we've got your recap and the videos for you here - www.crunchydata.com/blog/postgis...

Running queries on data that have nulls in them? Make your data more clear by specifying a special character for null with psql: \pset null 👻

It's not the new year, but these tips from @craigkerstiens.com may help your database to be in better shape well ahead of end of the year -

The pg_parquet extension benefits Postgres users who work with large or complex databases: Why is parquet so great? Two main reasons:

Know which queries consume the most time against your Postgres database? Pg_stat_statements will tell you if you don't already know: SELECT total_exec_time, mean_exec_time as avg_ms, calls, query FROM pg_stat_statements ORDER BY mean_exec_time DESC LIMIT 10; #dataBS

Do your kids have a break this week and need something to keep them entertained? How about teaching them a little about Postgres. We've got a Postgres playground tutorial designed just for kids -

When working with psql in Postgres you can edit queries using \e \e will open your default editor thats been defined with $EDITOR What's your $EDITOR set to?

The promise of Apache Iceberg. It's like pong for databases. #databs

Did you know you can automatically log all slow queries that take over a certain period of time with log_min_duration_statement? What time you set can vary based on your needs. Whats your recommended setting for logging on your Postgres database? #dataBS www.crunchydata.com/postgres-tip...

watching "PostGIS day" sessions, presented by @pwramsey.bsky.social and @crunchydata.com , loving it 🐘 www.crunchydata.com/community/ev...

Announcing Crunchy Data Warehouse! A next-generation Postgres-native data warehouse that provides full Iceberg support for fast analytical queries and transactions.Read more in our announcement. www.crunchydata.com/blog/crunchy...

We recently made a tweak to our blog to instead of showing random/topical images in our social images to showing the post itself. After all don't we all want to see more code? Would love to hear what you think - www.crunchydata.com/blog/pg_parq...

CREATE TABLE taxi_trips() with (load_from = 'https://d37ci6vzurychx.cloudfront.net/trip-data/yellow_tripdata_2024-02.parquet'); SELECT count(*) FROM taxi_trips;

One piece of this is always the performance, the other is how easy or hard it is. On Crunchy Bridge for Analytics it's literally two lines. @marcoslot.com and the entire team really nailed it on this one with developer experience.

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.

Always love a blog post that highlights some near learning in Postgres, this time rollup and cube by @sqlliz.bsky.social www.crunchydata.com/blog/easy-to...

Playing with @pwramsey.bsky.social 's OpenAI extension on Crunchy Bridge 🤯

A change to RelResultInfo - A Near Miss with Postgres 17.1 www.crunchydata.com/blog/a-chang...

We've got several team members out at #Kubecon this week. If you're there we'd love to say hi, stop by and grab an activity book or other swag from our booth.

Accessing large language models from Postgres www.crunchydata.com/blog/accessi...

Want to write better analytical queries @winsletts.bsky.social has you covered with a breakdown of 8 great tips and walkthroughs for writing better SQL - www.crunchydata.com/blog/8-steps...

But how does Google docs come into play? Google docs has this handy =importdata("url.csv") function that will auto-import data. So you can: * Write a query, click save * Share it, copy the url * Import into google docs * Chart/manipulate to your hearts content. All literally in under a minute.

Did you know when using psql \e will open your default $EDITOR to edit the last run query? Save and close and it'll execute that query.

You may have heard that we launched a data analytics engine with a combination of Postgres 🐘 and DuckDB 🦆. >> Why did we fuse DuckB with Postgres?

A couple weeks ago we released pg_parquet. With pg_parquet you can easily: * Export tables or queries from Postgres to Parquet files * Ingest data from Parquet files to Postgres * Inspect the schema and metadata of existing Parquet files Want to learn more?

Backups are out and snapshots are in! Brian breaks down everything you need to know for how to use pgBackRest with snapshots in a Kubernetes environment.

Data pipelines for IoT applications often involve multiple different systems and while a lot of interesting engineering goes into these systems, things are much simpler if you can do everything in Postgres.