Date: Mon, 19 May 2014 19:56:17 +0100 From: Matthew Seaman <matthew@FreeBSD.org> To: freebsd-ports-bugs@freebsd.org Subject: Re: ports/187286: [bsd.default-versions.mk] [patch] Default PostgreSQL version needs to be updated to 9.3 Message-ID: <537A53D1.4010506@FreeBSD.org> In-Reply-To: <201405191840.s4JIe2qE039124@freefall.freebsd.org> References: <201405191840.s4JIe2qE039124@freefall.freebsd.org>
next in thread | previous in thread | raw e-mail | index | archive | help
This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --seApPoJRLPuOAdvrAlhOLux5asajIceKR Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable On 19/05/2014 19:40, Dan Langille wrote: > Subject: Re: ports/187286: [bsd.default-versions.mk] [patch] Default Po= stgreSQL version needs to be updated to 9.3 > Date: Mon, 19 May 2014 14:37:33 -0400 > =20 > What needs to be done and how can I help? > =20 > Now that BSDCan is over, PGCon is about the start. I have *all* the =3D= > PostgreSQL developers here in Ottawa. I would advise against making Pg 9.3 the default right now. The performance problem exposed by Pg's switch from SysV SHM to mmap are quite significant, and the effect gets worse as things like eg. the size of work mem are increased -- so big Pg installations will get hit harder than small ones. There is definitely a problem from the FreeBSD side, which I believe Attilio is working on. But any fixes he comes up with are going to take some time to percolate into general release. It's not clear to me if the Pg code is doing anything "wrong" or not -- that would be good to establish. Also, if there is any sort of work-around that could be applied to the FreeBSD port of Pg 9.3 (and presumably 9.4 et seq.) to mitigate the problem. Cheers, Matthew --=20 Dr Matthew J Seaman MA, D.Phil. PGP: http://www.infracaninophile.co.uk/pgpkey --seApPoJRLPuOAdvrAlhOLux5asajIceKR Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG/MacGPG2 v2.0.20 (Darwin) Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQJ8BAEBCgBmBQJTelPcXxSAAAAAAC4AKGlzc3Vlci1mcHJAbm90YXRpb25zLm9w ZW5wZ3AuZmlmdGhob3JzZW1hbi5uZXQ2NTNBNjhCOTEzQTRFNkNGM0UxRTEzMjZC QjIzQUY1MThFMUE0MDEzAAoJELsjr1GOGkATpyEP/RRj5NwjiMCn/TSJDC31rwbU MFwGVQ8S4puxKJYhVpx1sg9Tlqiqw3uaurRKbEBqYJ1GtNng3DaVVBfmqmlXhDzM CBNrXWGTLgMFLRu5h7TbAiQ5g/068Onh+u8mlsxU0zh+3gmUtVPugFCyjpzeSUg8 TC03GI15oFmV44WwRUttMWe5O+jG9oj3MhQ/1p3+f+D/ceuYobE/OeL9KfqkKcVu AXRH4B5MWv50dzZAtWPZQZkSKwdPrRW9WXslXPQ7bh/gOYUt12jM+j2qogkHOedc p73irZOpps/b2RP9SvIdDq0oPOSUDIK65K30ySa98ism0RjoFruAhwYA38z62DAi RFikVMpJnhXuoVKT2YPHfiE4PtacG+zz//zuksfJmJm4Oa09wBOPV22k7xVj/o8r jvhtAJnLgpZ6UTGmdo1ZXpcGtJWr7Tb62FhMA++Wj3wUJ3Tj5IH7q891E+6wljKa Y3pJ0ZlybGdgfHt/rUBhw50e6qUGFBJ1VgCMZn4h3v07eiNWij2WxBGLDoRhO+qD uqtOReQvXMp2Hbg/Ja3rdQPdtAWyGZZwdr8ZRxk7Q397kyd7PcPYFnXXUaX2+j0C fMlv/G4FmC/YJr/oFfZnrXiII7E5rYbSvbqcqNA58RbzqKqTWdOcDAN7Uq0pKrdw tin4hSbS0d2RLUE5yhr4 =s/Mq -----END PGP SIGNATURE----- --seApPoJRLPuOAdvrAlhOLux5asajIceKR--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?537A53D1.4010506>