On 2013-04-22 10:25:34 -0400, Jonathan S. Katz wrote:
> On Apr 22, 2013, at 4:08 AM, Michael Banck wrote:
>
> > Hi,
> >
> > Am Freitag, den 19.04.2013, 09:41 -0700 schrieb Josh Berkus:
> >> So, here's what we potentially have as "worth mentioning":
> >>
> >> * Views (updatable, matviews)
> >> * Federation (writeable fdw, pgsql_fdw)
> >> * LATERAL
> >> * regex indexes
> >> * No more SHMMAX/SHMMALL
> >>
> >> Is that everything?
> >
> > I am not sure "No more SHMMAX/SHMMALL" should be in the top 5 - it is
> > quite nice that DBAs do not have to fiddle with it anyway, but will it
> > make people say "wow, *now* I will finally try PostgreSQL"? It does not
> > look like a major new feature to me, but rather (but not really) like a
> > bug-fix or implementation detail.
>
> For developers who have had so much trouble installing / running Postgres on their local machines, it is a big deal.
Idon't know how many people I have had to help install Postgres on their local environments because it would not run
rightout of the box.
Yea. Besides not understanding pg_hba.conf its probably the most
frequent problems I have seen with new (and not so new) users.
> > Unless I missed some huge performance gains due to it, in which case I
> > think it should be worded differently.
>
> That I definitely agree with. Perhaps along the lines of "Removed need to tweak OS shared memory settings?"
I'd still formulate it as "reduce" as you still need to change variables
if you have many clusters or higher max_connections.
Greetings,
Andres Freund
--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services