Re: PG version recommendation

On 5/7/19 11:52 AM, David Gauthier wrote:
> Hi:
>
> I'm going to be requesting a PG instance supported by an IT team in a
> large corp.  They will be creating the server as a VM.  We will be
> loading the DB using scripts (perl/dbi) on linux, possibly using bulk
> loading techniques if that's required.  Queries will come from both
> linux and the web, but typically the number of concurrent users will be
> on the order of 10 reads, maybe a couple writers.  < 1T total disk, no
> partitioning.  I will be requesting PITR.
>
> I need to pick a PG version in my request.  I want something that will
> be stable and reliable while, of course, being able to perform well.
> What would be a good choice for PG version ?

The latest production release v 11. You will have community support
until November 2023:

https://www.postgresql.org/support/versioning/

As will all suggestions test under your conditions to verify.

>
> Also, since the server will be a VM, are there any special
> recommendations/suggestions might I forward in the request (install
> options, tuning options, other) ?
>
> Thanks !

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com