Crunchy Data joins Snowflake. Read the announcement
Brandur Leach
Brandur Leach
The API powering our Crunchy Bridge product iswritten in Go, a language that provides a good compromise between productivityand speed. We're able to keep good forward momentum on getting new features outthe door, while maintaining an expected latency of low double digits ofmilliseconds for most API endpoints . A common pitfall for new projects in fast languages like Go is that theircreators, experiencing a temporary DX sugar high of faster compile and runtimespeeds than they've previous...
Read MoreMarco Slot
Marco Slot
Operational and analytical workloads have historically been handled by separatedatabase systems, though they are starting to converge. We built Crunchy Data Warehouse to putPostgreSQL at the frontier of analytics systems, using modern technologies like Iceberg and a hybrid query engine . Combining operational and analytical capabilities is extremely useful, but it isnot meant to drive all your workloads into a single system. In mostorganizations, application developers and analysts work...
Read MoreLouise Grandjonc Leinweber
Louise Grandjonc Leinweber
Postgres does a great job of making queries really efficient. By gathering datain internal statistics tables, Postgres estimates before a query is run lots ofthings - like will an index scan be better than a sequential scan. How to pulldata for the WHERE statement. What Postgres doesn’t know …. is how your columns are related to each other.Postgres isn’t a machine learning algorithm. It is not going to learn over timeas you query things what is related and what isn't. It uses the same stat...
Read MoreGreg Sabino Mullane
Greg Sabino Mullane
Someone recently asked on the Postgres mailing lists about how to removeunwanted duplicate rows from their table. They are “unwanted” in that sense thatthe same value appears more than once in a column designated as a primary key.We’ve seen an uptick in this problem since glibc was kind enough to change theway they sorted things. This can lead to invalid indexes when one upgrades theirOS and modifies the underlying glibc library. One of the main effects of a corrupted unique index is allowi...
Read MoreBrian Pace
Brian Pace
Postgres' ability to execute queries in parallel is a powerful feature that can significantly improve query performance,especially on large datasets. However, like all resources, parallel workers arefinite. When there aren't enough available workers, Postgres may downgrade aparallel query to a serial (non-parallel) execution. This sounds reasonableunless the performance of the downgraded query is well beyond the requiredresponse times needed by the application. While helping our clients w...
Read MoreElizabeth Christensen
Elizabeth Christensen
Materialized views are widely used in Postgres today. Many of us are workingwith using connected systems through foreign data wrappers, separate analyticssystems like data warehouses ,and merging data from different locations with Postgres queries. Materializedviews let you precompile a query or partial table, for both local and remotedata. Materialized views are static and have to be refreshed. One of the things that can be really important for using materialized viewsefficiently is inde...
Read MoreGreg Sabino Mullane
Greg Sabino Mullane
It is rare that a Postgres table keeps the exact same structure year after year.New columns get added. Old columns get dropped. Column data types need tochange. Those are all done with the ALTER TABLE command. One big drawback tothese changes is that they may force a complete table rewrite. A rewrite means acompletely new copy of the table is created, and then the old one is dropped.This can take a very long time for large tables. Worse, everything else isblocked/locked from using the tabl...
Read MorePaul Ramsey
Paul Ramsey
The number of cool things you can do with the http extension is large, but puttingthose things into production raises an important problem. The amount of time an HTTP request takes, 100s of milliseconds, is 10- to20-times longer that the amount of time a normal database query takes. This means that potentially an HTTP call could jam up a query for a long time. Irecently ran an HTTP function in an update against a relatively small 1000record table. The query took 5 minutes to run, and durin...
Read MoreGreg Sabino Mullane
Greg Sabino Mullane
The Postgres hackers mailing list( pgsql-hackers@postgresql.org ) is aninvaluable resource for anyone wanting to contribute to the PostgreSQL code. ThePostgres project does not use PRs (pull requests) or GitHub issues. So if youwant to contribute an idea, or help with code reviews, the hackers mailing listis the canonical way to do so. More information on contributing is on thePostgres wiki at: https://wiki.postgresql.org/wiki/So,_you_want_to_be_a_developer ? My colleagueElizabeth Christ...
Read MoreKeith Fiske
Keith Fiske
Crunchy Data is pleased to announce a new open source pgMonitor Extension .Crunchy Data has worked on a pgMonitor tool for several years as part of our Kubernetes and self-managed Postgres deployments and recently we’ve added an extension to the tool set. Two primary scenarios motivated the creation of the pgMonitor extension : 1. Quicker Metrics : Monitoring metrics often need quick response times toallow for frequent updates. We've noticed that certain metrics become sloweras the datab...
Read MoreThis site uses cookies for usage analytics to improve our service. By continuing to browse this site, you agree to this use. See ourprivacy policy to learn more.