One thing that the orbit application does is it generates a score for every community member

that's called the Love. Back in May, we decided to introduce materialized views inside of Postgres

in order to basically do these calculations. So we would do them in SQL and then we would store the

result in a materialized view. I thought it would be

great. It's very simple. Two or three months later, it turns out that the number one consumer of

I.O. on our database is the generation of these materialized views. It worked quite well when we were

ingesting one-tenth or one-hundredth of the activity, but it is certainly the approach that has not scaled.

My name is Josh Jellick.

I'm the co-founder and CTO at orbit.

This is Code Story, the podcast bringing you interviews with tech visionaries who share in the critical moments of what it takes to change in industry

and build and lead a team that has your back.

I'm your host, Noah Laphardt, and today how Josh Jellick took the orbit model

and created mission control for your community.

All this and more on Coat Story.

Josh Jellick is originally from the U.S., but lives in Paris now.

And because of this, he likes to take advantage and walk around to take in the sites.

He lives close to an area with a park featuring gardens and lots of trees,

and he goes there to clear his head, have a little bit of nature, and also to have walking meetings.

Josh likes to stay active through running, cycling, and the aforementioned walking meetings.

He's married with a 13-month-old

daughter. He met his wife, not in Paris or the U.S., but in Thailand. He jokes that his

young daughter is growing up faster than his company. He avidly confirms that the food in Paris

...