JSON Home Improvement at SCALE 14x
Slides from my JSON Home Improvement talk at SCALE 14x are now live. Practical techniques for working with JSON in PostgreSQL.
A simple JSON difference function
Build a JSONB diff function in PostgreSQL using jsonb_each and a clever LEFT JOIN to find keys that exist only on the left or have diverging values.
Doing a bulk merge in PostgreSQL 9.5
PostgreSQL 9.5's new UPSERT syntax doesn't work with COPY, but you can achieve the same result using file_fdw to mount CSV files as foreign tables and combine…
Always Do This #3: Log Lock Waits and Temp Files
PostgreSQL logging is a balancing act, but two settings always earn their keep: log_lock_waits and log_temp_files.
January SFPUG: What’s New in PostgreSQL 9.5?
PostgreSQL 9.5 is here—come see what's new at the SF PostgreSQL Users' Group meetup in January.
Always Do This #2: ssl_renegotiation_limit = 0
PostgreSQL's ssl_renegotiation_limit causes more problems than it solves. Here's why you should disable it, especially for long-lived connections.
Always Do This #1: Create New Clusters with Checksums
Always initialize PostgreSQL clusters with data checksums enabled to catch disk corruption early.
“The PCI-Compliant Database” at PGConfSV
Learn how to design a PostgreSQL database that meets PCI compliance requirements without sacrificing performance or usability.
Don’t Assume PostgreSQL is Slow
PostgreSQL's SERIAL can keep up with Redis for counters. Before adding caching layers, measure your actual bottlenecks—your intuition is probably wrong.
ProTip: Digital Ocean, Please Don’t Do This.
Hacktoberfest's t-shirt incentive flooded maintainers with low-quality pull requests, turning a well-meaning event into a nightmare of wasted review time.