Re: [GENERAL] effective_io_concurrency increasing

On Sun, Jun 18, 2017 at 6:02 PM, Patrick B wrote: > Hi guys. > > I just wanna understand the effective_io_concurrency value better. > > My current Master database server has 16 vCPUS and I use > ​​ > effective_io_concurrency = 0. > ​It seems as though the number of

Re: [GENERAL] effective_io_concurrency increasing

*As per the docs:* *1. This is dependent on whether or not you are using a RAID disk,2. "Some experimentation may be needed to find the best value"* *IOW, there is no general recommendation.* On Sun, Jun 18, 2017 at 9:24 PM, Patrick B wrote: > > > 2017-06-19 13:19

Re: [GENERAL] effective_io_concurrency increasing

2017-06-19 13:19 GMT+12:00 Melvin Davidson : > > > On Sun, Jun 18, 2017 at 9:02 PM, Patrick B > wrote: > >> Hi guys. >> >> I just wanna understand the effective_io_concurrency value better. >> >> My current Master database server has 16 vCPUS and I

Re: [GENERAL] effective_io_concurrency increasing

On Sun, Jun 18, 2017 at 9:02 PM, Patrick B wrote: > Hi guys. > > I just wanna understand the effective_io_concurrency value better. > > My current Master database server has 16 vCPUS and I > use effective_io_concurrency = 0. > > What can be the benefits of increasing

[GENERAL] effective_io_concurrency increasing

Hi guys. I just wanna understand the effective_io_concurrency value better. My current Master database server has 16 vCPUS and I use effective_io_concurrency = 0. What can be the benefits of increasing that number? Also, do you guys have any recommendations? I'm using PG 9.2 and the official

Re: [GENERAL] storing postgres data on dropbox

On 06/18/2017 01:13 PM, Martin Mueller wrote: I think I get it. 'base' is not the data directory but a child of var-9.5, which (with its entire path) is the "data directory". I honestly don't recall how I installed Posgres, but I'm pretty sure that I picked the default method from the

[GENERAL] Postgres Data Encryption Using LUKS with dm-crypt ?

Hello ppl, a few years ago I asked the same question but did not receive valued answers and we use different way to realize the project. Today I wanna ask did some one do it and most important for me, can some one share his experience ? What I should expect, what is good and bad things that

Re: [GENERAL] storing postgres data on dropbox

I think I get it. 'base' is not the data directory but a child of var-9.5, which (with its entire path) is the "data directory". I honestly don't recall how I installed Posgres, but I'm pretty sure that I picked the default method from the Postgres. Many thanks for your help, which is

Re: [GENERAL] storing postgres data on dropbox

On 06/18/2017 01:00 PM, Martin Mueller wrote: Did you mean that "/users/martin/Library ApplicationSupport/Postgres/var9.5/base/" is above or below the data directory? As I understand it Postgres is the highest Postgres specific directory. It contains just one child directory, var-9.5, which

Re: [GENERAL] storing postgres data on dropbox

Did you mean that "/users/martin/Library ApplicationSupport/Postgres/var9.5/base/" is above or below the data directory? As I understand it Postgres is the highest Postgres specific directory. It contains just one child directory, var-9.5, which has a lot of subdirectories, including

Re: [GENERAL] storing postgres data on dropbox

On 06/18/2017 11:29 AM, Martin Mueller wrote: How close is close enough? In my case, the machines run OS Sierra, and the installation uses the same directory paths Keeping the Postgres version in sync should be simple. Is that close enough? In MySQL you can copy and paste individual tables if

Re: [GENERAL] storing postgres data on dropbox

On Sun, Jun 18, 2017 at 06:29:50PM +, Martin Mueller wrote: > How close is close enough? In my case, the machines run OS > Sierra, and the installation uses the same directory paths > Keeping the Postgres version in sync should be simple. Is > that close enough? I am not an expert on that.

Re: [GENERAL] storing postgres data on dropbox

On Sun, Jun 18, 2017 at 06:29:50PM +, Martin Mueller wrote: > In MySQL you can copy and paste individual tables if the > data are kept in ISAM, but INNO is hopeless that way. Is > Postgres more like INNO than ISAM when it comes to table > storage? *more* like INNO but not at all *like* INNO

Re: [GENERAL] storing postgres data on dropbox

How close is close enough? In my case, the machines run OS Sierra, and the installation uses the same directory paths Keeping the Postgres version in sync should be simple. Is that close enough? In MySQL you can copy and paste individual tables if the data are kept in ISAM, but INNO is

Re: [GENERAL] storing postgres data on dropbox

> On Jun 18, 2017, at 10:58 AM, Karsten Hilbert wrote: > > On Sun, Jun 18, 2017 at 05:30:44PM +, Martin Mueller wrote: > >> Thank for this very helpful answer, which can be >> implemented for less than $100. For somebody who started >> working a 128k Mac in the

Re: [GENERAL] storing postgres data on dropbox

On Sun, Jun 18, 2017 at 05:30:44PM +, Martin Mueller wrote: > Thank for this very helpful answer, which can be > implemented for less than $100. For somebody who started > working a 128k Mac in the eighties, it is mindboggling that > for that amount you can buy a terabyte of storage in a

Re: [GENERAL] storing postgres data on dropbox

Thank for this very helpful answer, which can be implemented for less than $100. For somebody who started working a 128k Mac in the eighties, it is mindboggling that for that amount you can buy a terabyte of storage in a device that you put in a coat pocket. I'll read up on rsync On

Re: [GENERAL] storing postgres data on dropbox

On Sun, Jun 18, 2017 at 13:16:16 +, Martin Mueller wrote: Why not a PostgreSQL-database somewhere in the cloud? Good question, but it's a question of money and performance. I used MySQL for many years and then moved a dataset to an instance on AWS. The

Re: [GENERAL] storing postgres data on dropbox

On 06/18/2017 06:16 AM, Martin Mueller wrote: Why not a PostgreSQL-database somewhere in the cloud? Good question, but it's a question of money and performance. I used MySQL for many years and then moved a dataset to an instance on AWS. The performance was horribly slow. Then some kind soul at

Re: [GENERAL] storing postgres data on dropbox

Why not a PostgreSQL-database somewhere in the cloud? Good question, but it's a question of money and performance. I used MySQL for many years and then moved a dataset to an instance on AWS. The performance was horribly slow. Then some kind soul at my institution hooked me up with "Aurora,"

Re: [GENERAL] storing postgres data on dropbox

Am 18.06.2017 um 03:03 schrieb Martin Mueller: This is a queestion from a Postgresql novice. I use Postgresql in a single-user environment on a Mac with OS Sierra. I use AquaFold DataStudio as a client, which is nice but also keeps me woefully ignorant about many aspects of the underlying