JD,
> A lot. A whole lot, more than what most people have in production with
> more than that. You are forgetting a very large segment of the
> population who run... VMs.
Actually, even a "mini" AWS instance has 1GB of RAM. And nobody who
uses a "micro" is going to expect it to perform well under load. I
think it's completely reasonable to tell people running on < 1GB of ram
to tune PostgreSQL "down".
4MB work_mem / 64MB maint_work_mem still works fine at 1GB.
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com