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 172 — August 31, 2016
The Sizes of FTS Indices
Postgres has a number of index types - each with a different focus and tradeoffs. Here’s a look at a newer type, the RUM index, which may be larger but can provide some performance improvements.
Oleg Bartunov
PgSQL Indexes and LIKE Queries
Indexes in general make your queries faster. One common case for applications is LIKE %foo queries, and in some cases they can work and others not. This post lays out what you need to know to take advantage of them.
Paul Ramsey   #tutorial 
HTTP API to Read & Write Excel files
Turn messy CSV dumps into user-friendly and native Excel spreadsheets.
cloudxls    #sponsored 
Django and PostgreSQL: An Even-Closer Union
Christophe Pettus demonstrates Django 1.8 and 1.9’s Postgres-related features. 20 minutes.
DjangoCon US   #video 
PostgreSQL vs Hadoop
Chris Travers   #opinion 
Building a Scalable Postgres Metrics Backend using the Citus Extension
Will Leinweber   #tutorial 
pg_tail: 'tail -f' Your PostgreSQL Tables
Andre Parmeggiani   #tools 
csv2table: A CSV to Postgres Loader
While Postgres copy can work great, sometimes you want something simpler. Here’s a utility for loading directly from a CSV into a table, creating it and all.
Ryan Kelly   #tools 
Accessing Multiple Postgres Schemas from Django
Schemas allow some logical separation of tables within Postgres, which can be nice for a number of reasons. Django only requires a bit of work to be able to work with them as highlighted here.
AmvTek blog
A Table of Postgres Data Types to Redshift Data Types
Rob Story
Get 5+ Engineering Job Offers in 1 Week
With Hired, companies apply to hire you - get salary and equity offers before you interview from companies like Facebook, Postmates, & Square
Hired.​com    #job 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.