· 1 min · 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.

2 comments

· 2 min · PostgreSQL

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…

1 comment

· 1 min · PostgreSQL

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.

0 comments

· 1 min · PostgreSQL

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.

0 comments

· 1 min · PostgreSQL

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.

1 comment

· 1 min · PostgreSQL

Always Do This #1: Create New Clusters with Checksums

Always initialize PostgreSQL clusters with data checksums enabled to catch disk corruption early.

5 comments

· 1 min · PostgreSQL

“The PCI-Compliant Database” at PGConfSV

Learn how to design a PostgreSQL database that meets PCI compliance requirements without sacrificing performance or usability.

2 comments

· 2 min · Django

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.

14 comments

· 1 min · Tech Biz

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.

0 comments

· 2 min · PostgreSQL

UUID vs BIGSERIAL for Primary Keys

UUIDs cost slightly more than BIGSERIAL for inserts, but the performance hit is negligible—and they solve real problems like table merging and sharding that…

10 comments