Re: PG version recommendation

Поиск
Список
Период
Сортировка
От David Gauthier
Тема Re: PG version recommendation
Дата
Msg-id CAMBRECAZ38XAZD9sXtXAHcSxgDO_3KcAvHLjaB1953xNBvuFBg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PG version recommendation  (Ron <ronljohnsonjr@gmail.com>)
Ответы Re: PG version recommendation
Список pgsql-general
>>Home-rolled application, or third party? 
Are you asking about how they do VMs ?
They already provide PG v9.6.7 , so I gather they're not averse to supporting PG DBs. 


On Tue, May 7, 2019 at 4:05 PM Ron <ronljohnsonjr@gmail.com> wrote:
On 5/7/19 1:52 PM, 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 ?

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) ?

Home-rolled application, or third party?  If third party, they'll have something to say about supported version numbers.


--
Angular momentum makes the world go 'round.

В списке pgsql-general по дате отправления:

Предыдущее
От: Ron
Дата:
Сообщение: Re: PG version recommendation
Следующее
От: Tim Cross
Дата:
Сообщение: Re: PG version recommendation