Postgres Weekly
Archives| Latest| RSS
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.
« Prev
Next »
Postgres Weekly
Issue 174 — September 14, 2016
Yandex's Successful Migration From Oracle to PostgreSQL [PDF]
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.
Vladimir Borodin
A Tour of Postgres' Foreign Data Wrappers
Even if your data isn’t in a SQL database, you can use Postgres to connect to other data sources via foreign data wrappers (FDWs).
Craig Kerstiens   #tutorial 
Handling Very Large Tables in Postgres Using Partitioning
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.
Rimas Silkaitis   #tutorial 
Join us at DataLayer
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.
Compose | DataLayer    #sponsored 
Unique Partial Indexes with PostgreSQL
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.
Anderson Dias
PGConf Silicon Valley (Nov 15-16) Schedule Now Live
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.
PGConf Silicon Valley   #news 
Uniqueness in PostgreSQL: Constraints vs Indexes
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?
Lauren Ellsworth   #tutorial 
Calculating Proportional Values in SQL
Aggregations are common and generally straightforward in SQL, but some more complex operations like medians require a bit more work as demonstrated here.
Periscope   #tutorial 
Creating a Postgres Cluster using Helm, a Kubernetes Package Manager
Jeff McCormick   #tutorial 
Getting PostgreSQL Transactions Under Control with SQLAlchemy
Authentise, Inc   #tutorial 
Fun with SQL: Computing Run Rate & Month Over Month Growth
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.
Citus Data   #tutorial 
Recovering a Postgres Database From Disk Level Corruption
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.
Denish Patel   #tutorial 
pg-histogram: Functions for Generating Text-Based Histograms
This handy set of functions makes it easy to generate text-based histograms directly in Postgres.
David Wolever   #code 
Find Your Perfect Company Match
You're smart, you're efficient. Why job hunt the old way? Try Hired and get your profile in front of thousands of top tech companies.
Hired.​com    #sponsored 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.