Hacker News Reader

Some excellent new features in 9.3. My two favorite features are 1) not having to configure sysv shared memory anymore removing an installation step and 2) LATERAL JOIN which makes it easy to join with a set returning function (the subquery usage seems less useful in practice). See What's New for examples on how LATERAL can be used.

View on HN

Yes, it's interesting that they haven't mentioned removing the need to configure SysV shared memory. In my experience, a good number of developers initially miss out on this config / kernel setting, and wonder about their performance issues.

This feature will notably increase usability for people who are just getting started on Postgres. Now, I just wish they up the default config value from 32MB to something that's more in line with today's systems.

The default is determined by initdb, but was capped at 32MB due to the above issue. With this change, the cap's been bumped to 128MB.

Reply on news.ycombinator.com