Re: When to use PARTITION BY HASH?

2020-06-02 Thread MichaelDBA
Hi, I use it quite often, since I'm dealing with partitioning keys that have high cardinality, ie, high number of different values.  If your cardinality is very high, but your spacing between values is not uniform, HASH will balance your partitioned tables naturally.  If your spacing between

Re: Multiple postgresql clusters with same version and separate binaries

2019-01-04 Thread MichaelDBA
cluster instance running on the same host. Rui DeSousa <mailto:r...@crazybean.net> Friday, January 4, 2019 10:53 AM Don’t need separate binaries for each cluster; only separate binaries for each version needed; i.e. 9.6.1, 9.6.2, etc. MichaelDBA <mailto:michael...@sqlexec.co

Re: Multiple postgresql clusters with same version and separate binaries

2019-01-04 Thread MichaelDBA
To put it simply: you cannot run different major versions of PostgreSQL with the same binaries. 3 things need to be separate. You named 2 of them: data directory and port. The 3rd one is separate binary locations for each PG cluster instance running on the same host. What I do is create a se