Re: 9.3 Beta 1 Coming Soon! - Mailing list pgsql-advocacy

From Andres Freund
Subject Re: 9.3 Beta 1 Coming Soon!
Date
Msg-id 20130422142752.GG4052@awork2.anarazel.de
Whole thread Raw
In response to Re: 9.3 Beta 1 Coming Soon!  ("Jonathan S. Katz" <jonathan.katz@excoventures.com>)
Responses Re: 9.3 Beta 1 Coming Soon!  (David Fetter <david@fetter.org>)
List pgsql-advocacy
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


pgsql-advocacy by date:

Previous
From: "Jonathan S. Katz"
Date:
Subject: Re: 9.3 Beta 1 Coming Soon!
Next
From: Darren Duncan
Date:
Subject: fast spatial database in GPU