I'm blogging about Emacs, Drupal, php and exciting subjects

· Lars Nielsen

Postgres Kept Getting OOM-Killed. shared_buffers Was Set to 70% of RAM.

For about a day in August, the Postgres server behind my search engine kept dying. Not slowing down, not timing out: the Linux OOM killer was terminating it, roughly every 20 to 90 minutes at the worst point, and each kill meant a crash-recovery cycle of about 90 seconds while Postgres replayed its write-ahead log.

Read article Postgres Kept Getting OOM-Killed. shared_buffers Was Set to 70% of RAM.
· Lars Nielsen

One 42 MB Sitemap Froze the Whole Crawl Queue for 60 Hours

My search engine has a worker that discovers sitemaps: for each host that's due, it fetches the declared sitemap, walks any child sitemaps, and records what it found. For 60-odd hours in September, that worker made no progress at all. Every cycle it picked up the same host, crashed, and started over on the same host again. Every other host waiting for a sitemap check sat behind it.

Read article One 42 MB Sitemap Froze the Whole Crawl Queue for 60 Hours
Subscribe to Linkhub