Yandex is one of the larger email service providers in the world. At PgCon they gave a talk of how they migrated 300TB from Oracle to Postgres–a pretty impressive feat.
Partitioning can help restore query performance and deal with large volumes of data over time without having to resort to changing to a different data store.
Hear speakers from GitHub, Artsy, ZenDesk and many others as they discuss how their teams are optimizing the data layer to scale modern web and mobile apps. Reserve your seat now for this one day event on Sept. 28 in Seattle.
Unique indexes aren’t new, but in certain cases you need your data to be unique based on some value. Conditional indexes are the answer and aren’t too complicated to put in place.
PGConf Silicon Valley is back. If you’re interested in attending early bird tickets are on sale and we’ve got a discount code for 10% off if you use code PostgresWeekly.
Constraints and indexes come at a cost: they add write overhead with each INSERT and UPDATE and they can take up significant amounts of space. Since they both enforce uniqueness, which should we prefer and how are they different?
Aggregations are common and generally straightforward in SQL, but some more complex operations like medians require a bit more work as demonstrated here.
A walk through a complex query which calculates run rates and percentage growth rate over time for an ‘as-a-service’ business. It breaks the query apart step by step and leverages a number of Postgres features such as CTEs and window functions.
When disk corruption occurs, there’s a number of steps you can take. This post does a good job of walking through one case of disk corruption and how they recovered data.
