Database latency of Heroku, AWS EC2, and Hetzner with CrunchyData on the AWS region.
The winner is Heroku!
The winner is Heroku!
February 10, 2026 at 12:52 AM
Database latency of Heroku, AWS EC2, and Hetzner with CrunchyData on the AWS region.
The winner is Heroku!
The winner is Heroku!
We recently announced a new open source extension - pg_parquet - that makes it easy to:
* Export tables or queries to Parquet files
* Ingest data from parquet files into Postgres
* Inspect the schema and metadata of parquet files
Check it out on github: github.com/CrunchyData/...
* Export tables or queries to Parquet files
* Ingest data from parquet files into Postgres
* Inspect the schema and metadata of parquet files
Check it out on github: github.com/CrunchyData/...
GitHub - CrunchyData/pg_parquet: Copy to/from Parquet in S3 from within PostgreSQL
Copy to/from Parquet in S3 from within PostgreSQL. Contribute to CrunchyData/pg_parquet development by creating an account on GitHub.
github.com
October 28, 2024 at 12:53 PM
We recently announced a new open source extension - pg_parquet - that makes it easy to:
* Export tables or queries to Parquet files
* Ingest data from parquet files into Postgres
* Inspect the schema and metadata of parquet files
Check it out on github: github.com/CrunchyData/...
* Export tables or queries to Parquet files
* Ingest data from parquet files into Postgres
* Inspect the schema and metadata of parquet files
Check it out on github: github.com/CrunchyData/...
I'm thinking of migrating the database from Heroku to CrunchyData.
Should I do this? Please talk me out of it 😅
Should I do this? Please talk me out of it 😅
January 29, 2026 at 8:44 PM
I'm thinking of migrating the database from Heroku to CrunchyData.
Should I do this? Please talk me out of it 😅
Should I do this? Please talk me out of it 😅
Always exciting to launch a new open source project,
pg_parquet enables you to read and write Parquet files in S3 from PostgreSQL using regular COPY commands.
github.com/crunchydata/...
pg_parquet enables you to read and write Parquet files in S3 from PostgreSQL using regular COPY commands.
github.com/crunchydata/...
GitHub - CrunchyData/pg_parquet: Copy to/from Parquet in S3 from within PostgreSQL
Copy to/from Parquet in S3 from within PostgreSQL. Contribute to CrunchyData/pg_parquet development by creating an account on GitHub.
github.com
October 21, 2024 at 9:07 PM
Always exciting to launch a new open source project,
pg_parquet enables you to read and write Parquet files in S3 from PostgreSQL using regular COPY commands.
github.com/crunchydata/...
pg_parquet enables you to read and write Parquet files in S3 from PostgreSQL using regular COPY commands.
github.com/crunchydata/...
pg_cron: Cron-Jobs direkt in der Datenbank / Cron jobs directly in the database geoobserver.de/2026/09/22/p... via @crunchydata #pg_cron #PostgreSQL #PostGIS #gistribe #gischat #fossgis #foss4g #OSGeo #spatial #geospatial #opensource #gis #geo #geoObserver pls RT
September 22, 2026 at 7:18 AM
pg_cron: Cron-Jobs direkt in der Datenbank / Cron jobs directly in the database geoobserver.de/2026/09/22/p... via @crunchydata #pg_cron #PostgreSQL #PostGIS #gistribe #gischat #fossgis #foss4g #OSGeo #spatial #geospatial #opensource #gis #geo #geoObserver pls RT
Already had several people send me notes saying pg_parquet was the perfect tool for moving data to and from Postgres and S3 for them. Small sharp tools FTW.
GitHub - CrunchyData/pg_parquet: Copy to/from Parquet in S3 from within PostgreSQL
Copy to/from Parquet in S3 from within PostgreSQL. Contribute to CrunchyData/pg_parquet development by creating an account on GitHub.
github.com
October 25, 2024 at 6:00 PM
Already had several people send me notes saying pg_parquet was the perfect tool for moving data to and from Postgres and S3 for them. Small sharp tools FTW.
Latest update. I created the EC2 instance in the same availability zone (not just same region) as the CrunchyData database and now the latency is just 0.3ms, which is awesome!
February 10, 2026 at 10:58 AM
Latest update. I created the EC2 instance in the same availability zone (not just same region) as the CrunchyData database and now the latency is just 0.3ms, which is awesome!
pgSimload v.1.4.7 monthly build released!
Built with Go 1.24.3, dependencies upgrades:
- toolchain => go1.24.3
- github.com/jackc/pgx/v5 => v5.7.5
- golang.org/x/crypto => v0.38.0
- golang.org/x/sys => v0.33.0
- golang.org/x/text => v0.25.0
github.com/CrunchyData/...
Built with Go 1.24.3, dependencies upgrades:
- toolchain => go1.24.3
- github.com/jackc/pgx/v5 => v5.7.5
- golang.org/x/crypto => v0.38.0
- golang.org/x/sys => v0.33.0
- golang.org/x/text => v0.25.0
github.com/CrunchyData/...
github.com
May 26, 2025 at 8:16 AM
pgSimload v.1.4.7 monthly build released!
Built with Go 1.24.3, dependencies upgrades:
- toolchain => go1.24.3
- github.com/jackc/pgx/v5 => v5.7.5
- golang.org/x/crypto => v0.38.0
- golang.org/x/sys => v0.33.0
- golang.org/x/text => v0.25.0
github.com/CrunchyData/...
Built with Go 1.24.3, dependencies upgrades:
- toolchain => go1.24.3
- github.com/jackc/pgx/v5 => v5.7.5
- golang.org/x/crypto => v0.38.0
- golang.org/x/sys => v0.33.0
- golang.org/x/text => v0.25.0
github.com/CrunchyData/...
Not really new, they got this in the CrunchyData acquisition and it looks like they've released it in a new repo. Don't know what SNOWs play would be here.
November 4, 2025 at 5:18 PM
Not really new, they got this in the CrunchyData acquisition and it looks like they've released it in a new repo. Don't know what SNOWs play would be here.
CrunchyData Warehouse all looks very impressive: www.crunchydata.com/blog/crunchy.... Impressed to see them build on industry primitives like Apache Iceberg, and materializing PostgreSQL data marts so seamlessly. Super interested to see how this works with fast moving datasets.
www.crunchydata.com
November 21, 2024 at 6:53 PM
CrunchyData Warehouse all looks very impressive: www.crunchydata.com/blog/crunchy.... Impressed to see them build on industry primitives like Apache Iceberg, and materializing PostgreSQL data marts so seamlessly. Super interested to see how this works with fast moving datasets.
Happy PostGIS Day!
I've been enjoying the Crunchydata talks. There have been some interesting polls, including one on GeoParquet, which showed that only 19% (of poll takers) currently use GeoParquet. In comparison, over 50% are not, & another 26% want to but aren't yet.
I've been enjoying the Crunchydata talks. There have been some interesting polls, including one on GeoParquet, which showed that only 19% (of poll takers) currently use GeoParquet. In comparison, over 50% are not, & another 26% want to but aren't yet.
November 21, 2024 at 6:58 PM
Happy PostGIS Day!
I've been enjoying the Crunchydata talks. There have been some interesting polls, including one on GeoParquet, which showed that only 19% (of poll takers) currently use GeoParquet. In comparison, over 50% are not, & another 26% want to but aren't yet.
I've been enjoying the Crunchydata talks. There have been some interesting polls, including one on GeoParquet, which showed that only 19% (of poll takers) currently use GeoParquet. In comparison, over 50% are not, & another 26% want to but aren't yet.
Maybe a bit ironic, but I went from Heroku to AWS (EC2) + Crunchydata and I pay $10 per month 🤣
June 7, 2026 at 12:06 PM
Maybe a bit ironic, but I went from Heroku to AWS (EC2) + Crunchydata and I pay $10 per month 🤣
So, sadly, Heroku is gone. Where should we migrate to? I think I'll try Hatchbox, anything better?
I absolutely loved Heroku, it was so easy and (for me) it never went down.
Database is already migrated to CrunchyData. Redis is going away, so migrating will be relatively easy
I absolutely loved Heroku, it was so easy and (for me) it never went down.
Database is already migrated to CrunchyData. Redis is going away, so migrating will be relatively easy
February 6, 2026 at 5:43 PM
So, sadly, Heroku is gone. Where should we migrate to? I think I'll try Hatchbox, anything better?
I absolutely loved Heroku, it was so easy and (for me) it never went down.
Database is already migrated to CrunchyData. Redis is going away, so migrating will be relatively easy
I absolutely loved Heroku, it was so easy and (for me) it never went down.
Database is already migrated to CrunchyData. Redis is going away, so migrating will be relatively easy
Last week we @crunchydata.bsky.social released pg_parquet to make it easy to move data in/out of Postgres from parquet files. If you think that's helpful to you, find it interesting, or want to support it we'd love for you to visit the repo and give it a star github.com/CrunchyData/...
GitHub - CrunchyData/pg_parquet: Copy to/from Parquet in S3 from within PostgreSQL
Copy to/from Parquet in S3 from within PostgreSQL. Contribute to CrunchyData/pg_parquet development by creating an account on GitHub.
github.com
October 21, 2024 at 8:25 PM
Last week we @crunchydata.bsky.social released pg_parquet to make it easy to move data in/out of Postgres from parquet files. If you think that's helpful to you, find it interesting, or want to support it we'd love for you to visit the repo and give it a star github.com/CrunchyData/...
PostgreSQL: Index-Typen / Index types geoobserver.de/2026/01/27/p... via @crunchydata #PostGIS #PostgreSQL #gistribe #gischat #fossgis #foss4g #OSGeo #spatial #geospatial #opensource #gis #geo #geoObserver pls RT
January 27, 2026 at 8:03 AM
PostgreSQL: Index-Typen / Index types geoobserver.de/2026/01/27/p... via @crunchydata #PostGIS #PostgreSQL #gistribe #gischat #fossgis #foss4g #OSGeo #spatial #geospatial #opensource #gis #geo #geoObserver pls RT
I did a pgSimload rebuild release v.1.4.3 by today.
Fixes a flaw the x/crypto/ssh go library (CVE-2024-45337)
github.com/CrunchyData/...
Fixes a flaw the x/crypto/ssh go library (CVE-2024-45337)
github.com/CrunchyData/...
Release v.1.4.3 · CrunchyData/pgSimload
Version 1.4.3 (December, 16th 2024)
Major changes
none this is mostly a monthly build, to refresh dependencies'versions
Minor changes
rebuild of binaries with dependencies updates:
upgraded gol...
github.com
December 16, 2024 at 12:39 PM
I did a pgSimload rebuild release v.1.4.3 by today.
Fixes a flaw the x/crypto/ssh go library (CVE-2024-45337)
github.com/CrunchyData/...
Fixes a flaw the x/crypto/ssh go library (CVE-2024-45337)
github.com/CrunchyData/...
ST_CoverageClean & Co: Clean & Build ab PostGIS 3.6 geoobserver.de/2025/08/29/s... via @crunchydata #gistribe #gischat #fossgis #foss4g #OSGeo #spatial #geospatial #opensource #PostGIS #gis #geo #geoObserver pls RT
August 29, 2025 at 7:17 AM
ST_CoverageClean & Co: Clean & Build ab PostGIS 3.6 geoobserver.de/2025/08/29/s... via @crunchydata #gistribe #gischat #fossgis #foss4g #OSGeo #spatial #geospatial #opensource #PostGIS #gis #geo #geoObserver pls RT
The postgres operator from @crunchydata.com is really sweat. Makes it so much easier to run any Postgresql workload in your kubernetes cluster. Love it!
Their operator is opensource and can be found here: github.com/CrunchyData/...
Their operator is opensource and can be found here: github.com/CrunchyData/...
November 24, 2024 at 12:26 PM
The postgres operator from @crunchydata.com is really sweat. Makes it so much easier to run any Postgresql workload in your kubernetes cluster. Love it!
Their operator is opensource and can be found here: github.com/CrunchyData/...
Their operator is opensource and can be found here: github.com/CrunchyData/...
Unexpected highlight: a deep dive into #Kubernetes & #Helm with Alexander "Ananace" Olofson. Learned #Tanka is alive, #Cue is worth exploring, and there are awesome chart sources (Zalando, CrunchyData, CNPG, Percona) beyond #Bitnami.
February 1, 2025 at 6:02 PM
Unexpected highlight: a deep dive into #Kubernetes & #Helm with Alexander "Ananace" Olofson. Learned #Tanka is alive, #Cue is worth exploring, and there are awesome chart sources (Zalando, CrunchyData, CNPG, Percona) beyond #Bitnami.
@Snowflake buys @CrunchyData to add more bite to its #AI agents - by @Mike_Wheatley on @SiliconANGLE bit.ly/43TAgMV >> The addition of #PostGreSQL is a win for #CxOs and developers - and the #OpenSource Standards. #SnowFlakeSummit #NextGenApps
June 7, 2025 at 1:52 PM
@Snowflake buys @CrunchyData to add more bite to its #AI agents - by @Mike_Wheatley on @SiliconANGLE bit.ly/43TAgMV >> The addition of #PostGreSQL is a win for #CxOs and developers - and the #OpenSource Standards. #SnowFlakeSummit #NextGenApps
I wrote up a summary of resources for sharpening your PostgreSQL, SQL, and relational database skills.
The common denominator for all of these is that you have to be *doing* (modeling, writing SQL, and wrangling data) to get better.
still.visualmode.dev/blogmarks/6
The common denominator for all of these is that you have to be *doing* (modeling, writing SQL, and wrangling data) to get better.
still.visualmode.dev/blogmarks/6
January 24, 2025 at 10:27 PM
I wrote up a summary of resources for sharpening your PostgreSQL, SQL, and relational database skills.
The common denominator for all of these is that you have to be *doing* (modeling, writing SQL, and wrangling data) to get better.
still.visualmode.dev/blogmarks/6
The common denominator for all of these is that you have to be *doing* (modeling, writing SQL, and wrangling data) to get better.
still.visualmode.dev/blogmarks/6
I use CrunchyData for the database. A managed solution. I'm not interested to manage my own database.
February 10, 2026 at 3:48 PM
I use CrunchyData for the database. A managed solution. I'm not interested to manage my own database.
pgSimload v.1.4.5 released today. A good number of minor changes, including better compiled binaries.
More info on github.com/CrunchyData/...
More info on github.com/CrunchyData/...
Release v.1.4.5 · CrunchyData/pgSimload
Version 1.4.5 (February, 13th 2025)
Major changes
none this is mostly a monthly build, to refresh dependencies'versions
Minor changes
corrected a bug where -loops <number> could be ignored when...
github.com
February 13, 2025 at 1:48 PM
pgSimload v.1.4.5 released today. A good number of minor changes, including better compiled binaries.
More info on github.com/CrunchyData/...
More info on github.com/CrunchyData/...
I'm running Hetzner and AWS at the same time. And I do database backups at CrunchyData (the default) and Snapshooter.
If EC2 is down, I can quickly change the DNS to the Hetzner instance. But if EC2 is down, CrunchyData(same AZ) probably is down as well, so it won't matter that much anyways...
If EC2 is down, I can quickly change the DNS to the Hetzner instance. But if EC2 is down, CrunchyData(same AZ) probably is down as well, so it won't matter that much anyways...
February 10, 2026 at 1:17 PM
I'm running Hetzner and AWS at the same time. And I do database backups at CrunchyData (the default) and Snapshooter.
If EC2 is down, I can quickly change the DNS to the Hetzner instance. But if EC2 is down, CrunchyData(same AZ) probably is down as well, so it won't matter that much anyways...
If EC2 is down, I can quickly change the DNS to the Hetzner instance. But if EC2 is down, CrunchyData(same AZ) probably is down as well, so it won't matter that much anyways...