Introducing Crunchy Data Warehouse: A next-generation Postgres-native data warehouse. Crunchy Data Warehouse Learn more
Craig Kerstiens
Craig Kerstiens
We spend a lot of time at Crunchy Data helping people dig into the performance of their Postgres. If you're setting up a new Postgres database or already running on in production there are a number of very basic steps you can take that will save your tail in the future when it comes to investigating performance. Here is your guide that'll take less than 5 minutes to get in place. Future you will thank you for doing this today. Pg_stat_statements records and parameterizes queries, how long the...
Read MoreCraig Kerstiens
Craig Kerstiens
For developers who have been around SQL long enough, they know that there is often more than one way to get the same result. Today I wanted to look at a few different ways to aggregate and show a total with paid and unpaid status. First, we will use a common table expression ( CTE ), which is a nice method for organizing subqueries. Second, we use statements within aggregation context to filter out the values we want. Lastly, we use to clean up the syntax, but effectively do the same as th...
Read MoreCraig Kerstiens
Craig Kerstiens
Postgres is a great database with a ton of features including really rich indexing . Postgres itself maintains all sorts of data under the covers about things like cache hits and misses, when indexes are and aren't used , and more. If you're staring at a complex explain plan you may think some well targeted indexes may help, but how can you be sure? Enter HypoPG , a Postgres extension for adding hypothetical indexes to Postgres so you can do index planning. HypoPG supports hypothetical inde...
Read MoreCraig Kerstiens
Craig Kerstiens
If you are like us, Tailscale was an obvious tool to add to our network — as soon as we saw it, we knew we needed it. For those who haven’t tried Tailscale yet, it’s best described as a programmable, re-sizeable, distributed private network mesh. Yes, it’s that great. The better part is that Tailscale is fairly simple, and because it’s simple, it is easy to get correct. When we set out to build Crunchy Bridge we wanted to ensure you could build safely from day one. This included features suc...
Read MoreCraig Kerstiens
Craig Kerstiens
A question recently came up in the internal Crunchy Data slack channel: Does anyone actually use enums out in the wild? If you're unfamiliar with enums, they’re enumerated types, a static set of values in a database like days of the week or a shipping status. Enums are a powerful feature of Postgres that allows you to define a set of predefined values that can be assigned to a column. However, enums can have some limitations and drawbacks that make them less than ideal for certain scenarios. L...
Read MoreCraig Kerstiens
Craig Kerstiens
I wanted to take a little time today to walk through some of the security and team controls you get out of the box on Crunchy Bridge . Within teams for Crunchy Bridge you have the ability to: • Restrict authentication for a team to SSO • Event logs of all actions for a team • Audit logs of queries run against your database Restrict authentication for a team to SSO Event logs of all actions for a team Audit logs of queries run against your database We'll take a look at each of these in dee...
Read MoreCraig Kerstiens
Craig Kerstiens
In my career I've worked on teams that ran and managed over a million databases, and I've helped shard and scale database for customers at 100s of terabytes. Postgres is an incredibly flexible database , and because of it's flexibility you have a lot of options for architecting your data design for your application needs. In talking with current customers and future customers how you design and architect your database is a common topic. We're going to dig into some of the flexibility on archi...
Read MoreCraig Kerstiens
Craig Kerstiens
We love Postgres and want it to be available to as many as possible. This is why we released our playground for people to come and learn Postgres. This is why we write about using Postgres and why we published our Postgres tips . Today, we launch two updates to make Postgres even more available to developers. 1. Hobby tier plans now begin at $10 a month. This the same full-featured Postgres all our customers get. No packed multi-tenant setups. 2. When you spend under 5 in billing — there is...
Read MoreCraig Kerstiens
Craig Kerstiens
Postgres is an awesome database for a lot of reasons, put simply it's a really feature rich, powerful, and reliable database. One of those rich areas is the many built-in functions in Postgres. Let's take a look at a few of my favorites. First, let's start with one of the most simple built-in ones but when doing things with time is quite handy. Want to know what time it is according to your database? Want to know the biggest date in your data? Now let's look at one that is a little bit more int...
Read MoreCraig Kerstiens
Craig Kerstiens
Today I'm excited to introduce a new place for devs to polish their Postgres skills, a Postgres Playground and Tutorials from Crunchy Data. What is the playground? Put simply it is: 1. Postgres running in your local web browser 2. With canned datasets you can load 3. Guided tutorials to follow along to learn about the power of Postgres Postgres running in your local web browser With canned datasets you can load Guided tutorials to follow along to learn about the power of Postgres Wait?!?!? Pos...
Read More