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