Jacob Kaplan-Moss

Activity tagged “for:jdunck”

Bookmarks

Wikipedia: Site internals, configuration, code examples and management issues (PDF)

Loads of information about the tech behind Wikipedia. I've become convinced that the only sane way to design scalable systems is by studying the trials and tribulations of others.

(architecture, for:jdunck, hardware, infrastructure, lighttpd, memcached, mysql, performance, scaling, sysadmin, via:simonw, web, webdev, wikipedia)

Efficient SQL

Greg Mullane's complete talk on optimizing postgresql. Looks like a few things have changed since 2003 (7.3 —> 8.2), but this still seems *very* relevant.

(database, for:jdunck, for:mcroydon, optimization, performance, postgresql, sql, tuning)

EXPLAIN plan Operators

Ridiculously in-depth explanation of what PostgreSQL means when you ask it to EXPLAIN. This is probably the only place this information lives.

(for:jdunck, for:mcroydon, performance, postgresql)