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 178 — October 12, 2016
Faster PostgreSQL Counting
Counting in Postgres is often thought to be slow, but it doesn’t necessarily have to be. This rundown provides the ways you can count from exact to approximate, what trade-offs are, and some guide of when you should consider each.
Citus Data
Debugging PostgreSQL Performance, The Hard Way
When JustWatch saw a disproportionate increase in database reads they decided to find out why — instead of just throwing money at the problem.
JustWatch
How Twitch Uses PostgreSQL
Twitch has over 100 servers running Postgres and in this short post, they share a few parts of how they make it all work.
Aaron Brashears
Get The Essential Guide to Queuing Theory
This intro to queueing theory demystifies the subject without requiring pages full of equations. Get it now.
VividCortex    #sponsored 
Best of PostgreSQL 9.6 for the Database Administrator
Postgres 9.6 came with a number of interesting new features. This rundown highlights the one that are most interesting if you’re a DBA.
Kaarel Moppel   #opinion 
Large Text Indexes in Postgres
If you have large text columns and are looking to index you may want to think twice, or at least dig into see what your options are. By default they can be quite large and a few small tactics can greatly reduce their footprint.
Andrew Kane   #tutorial 
Some Full-Text Search Tricks
Postgres full-text search isn’t quite as specialized as some other FTS only systems, but can be powerful. If you are using it, here’s some handy tips on how to write the same query but achieve much different performance.
Live Journal   #tutorial 
DBGlass: A Cross-platform PostgreSQL Client
Built with Electron, React, Redux, and FixedDataTable.
Web-Pal   #tools 
repmgr 3.2 Released: Set Up Streaming Replication in A Cluster
postgresql.​org   #tools 
pglite: A Tiny (Shell) Script to Manage Ephemeral Postgres Databases
Jason Dusek   #tools 
How Distributed Outer Joins on PostgreSQL with Citus Work
Joins are one of the powerful features of SQL, and while outer joins aren’t as common as inner ones in certain cases they’re especially useful. Here’s a quick look at how they work in a distributed fashion with Citus.
Citus Data
7 Useful SQL and Postgres Techniques
A handy list of Postgres tips, most relating in some way to either JSON or Arrays, both of which still aren’t talked about or used often enough in Postgres.
Jeremy Raines
One Application, 4,000+ Opportunities - Try Hired
On Hired companies apply to interview you. Get 1:1 support for your job search plus upfront compensation details.
Hired    #sponsored 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.