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.klaver@aklaver.com