Date: Wed, 23 Jul 2014 14:39:45 +0100 From: Matthew Seaman <m.seaman@infracaninophile.co.uk> To: freebsd-questions@freebsd.org Subject: Re: freebsd + postgresql Message-ID: <53CFBB21.1090608@infracaninophile.co.uk> In-Reply-To: <20140723130211.GQ1848@mordor.lan> References: <20140723130211.GQ1848@mordor.lan>
next in thread | previous in thread | raw e-mail | index | archive | help
This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --HhuITkmB7idspxosXPAPcGRjVTSqC4KjE Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable On 07/23/14 14:02, Julien Cigar wrote: > Any idea if the changes/patches from > https://www.kib.kiev.ua/kib/pgsql_perf_v2.0.pdf will be merged to > 10-STABLE soon? We have a rather old PostgreSQL that we would like to > upgrade soon .. Those precise patches are unlikely to be committed anywhere, as they are proof of concept / exploratory stuff only. However, it's pretty easy to apply them to 10-STABLE or 10.0-RELEASE sources and compile your own custom kernel. Don't believe blindly that these patches will improve performance for you. Test against your own workload to be sure. Best recommendation at the moment is to stick with postgresql-9.2.x -- unless your database is small enough to fit entirely within RAM, in which case you could well find that upgrading to pg 9.3 makes little difference to performance. But, like I said, don't take anyone's word on it: measure your performance and be certain. Cheers, Matthew --HhuITkmB7idspxosXPAPcGRjVTSqC4KjE Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQJ8BAEBCgBmBQJTz7snXxSAAAAAAC4AKGlzc3Vlci1mcHJAbm90YXRpb25zLm9w ZW5wZ3AuZmlmdGhob3JzZW1hbi5uZXQxOUYxNTRFQ0JGMTEyRTUwNTQ0RTNGMzAw MDUxM0YxMEUwQTlFNEU3AAoJEABRPxDgqeTnzQkP/0dXsxaY/rGXeOeSKVHzucqD swMgoFGmvGXOZeFWv9m8ZJ6G0xPORexkXQlrfWyPr2D01klG5x5jR0/emR7fLKaI gIf9ihCFK328jZUUBb/VYHde92ysp1YZZ8bj328vIOtyXcEeodIoIIwBrlVi3vXE 5eMpGKS2zfr+FKs32Gah8iTdVCaIzUAs1qIm9QECE403cLFqZwH5qc8XWHFfCC0m wP5nxw04uYTE9AVUWKM7BT5iDXJfe0wXBCYiYj+pFDTmMRPMHtFBJ3QtZ0Rw8YAj TCY94a1nPPR9Z414OaiL1TnOPvtIU6ZSYWC0dgud5QJDTLaHusIS6hyBzY/RU+W8 fyO1ELu2k3A/fWfnequ2pRpnza5WyJle31ingpHgIPlrnXlNOepdeMAWKQmj8wgI VmrEz3Zq3X58NaME2AcE5Wfe6otBvuL8bc/CNw9Llo+XUAgso1Xjv11tGj2f/ZWc /6X+TUv3E1PV23ZckZgdr1/7GVlJ3HiyCyFw/93cvfdq2PQa1Kltr4PqdT8Qx4dW EDWo7p63mtRRqblyeSEiTyjBBq8qQxsHwKBEW+U+Oit/G2LV80UY6tEFQydk6jeJ Quls4oGDFOGDN9pEebGIsuGu+MXIuBRhpigpVW71j69/EwUgAE8zkpVYjUmXgGSk TVpJtFUw6kUC/mReCV/j =0n3n -----END PGP SIGNATURE----- --HhuITkmB7idspxosXPAPcGRjVTSqC4KjE--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?53CFBB21.1090608>