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…
PostgreSQL's SERIAL can keep up with Redis for counters. Before adding caching layers, measure your actual bottlenecks—your intuition is probably wrong.
Hacktoberfest's t-shirt incentive flooded maintainers with low-quality pull requests, turning a well-meaning event into a nightmare of wasted review time.
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…