Best Press Release Ever?
"After mooching off the open source world for 10 years and making millions, Backcountry.com finally threw the Postgres community a bone in the form of a database synching tool curiously called Bucardo."
How to port your gem to Ruby 1.9 - 世界線航跡蔵
pg_search: How I Learned to Stop Worrying and Love PostgreSQL full-text search
PostgreSQL Full Text Search is often good enough
Rubyrep with PostgreSQL DB syncing
PostgreSQL: Automating monthly table partitions - imperialWicket
Table partitioning - PostgreSQL wiki
SQL Window Functions and You - The Hashrocket Blog
SQL Window Functions and You
MySQL is done. It's the Postgres Age. by Jeff Dickey
More on Postgres Performance - Craig Kerstiens
sql - Insert, on duplicate update (postgresql) - Stack Overflow
Handy SO question on performing upserts
PostgreSQL: Documentation: 9.2: Controlling Text Search
"Such a lexeme will match any word in a tsvector that begins with the given string"
PostgreSQL: Documentation: 9.2: unaccent
"unaccent is a text search dictionary that removes accents (diacritic signs) from lexemes. It's a filtering dictionary, which means its output is always passed to the next dictionary (if any), unlike the normal behavior of dictionaries. This allows accent-insensitive processing for full text search"
UPSERT/MERGE using Writable CTE in PostgreSQL 9.1 | Database Technologies
PostgreSQL: Broken/non-ASCII characters in PostgreSQL
Database Soup: Why you need to apply today's update real soon
Don’t stop PostgreSQL’s autovacuum with your application | gocept weblog
How to check when postgresql tables were last auto-analyzed and auto-vacumned
sql - PostgreSQL Index Usage Analysis - Stack Overflow
handy SQL snippet for finding possible missing indexes in psql
GIN Vs GiST For Faceted Search With Postgres Full Text Indexes - Gary Sieling
Understanding Full Text Search in PostgreSQL LG #164
Implementing Multi-Table Full Text Search with Postgres in Rails
Linux Wizard – PostgreSQL tips : quickly add a surrogate key column
Triggers in PostgreSQL – Quick Example! | coding tiger
Example of accessing inserted data from a trigger
PostgreSQL: Documentation: 9.2: Using EXPLAIN
PostgreSQL tips and tricks
johto's lair: UPSERTisms in Postgres
partitioned/PARTITIONING_EXPLAINED.txt at master · fiksu/partitioned
fiksu/partitioned
Postgres database table partitioning support for Rails
PostgreSQL + WAL-E + Cloudfiles = Awesome
dockerfdw - controlling docker via postgres