Re: Slow response to my query
Goke Aruna <goksie@gmail.com>
From: Goke Aruna <goksie@gmail.com>
To: Bzzzz <lazyvirus@gmx.com>
Cc: Keith <keith@keithf4.com>, Steven Pousty <steve.pousty@gmail.com>, pgsql-novice@lists.postgresql.org, Babatunde Adeyemi <barbietunnie@gmail.com>
Date: 2019-11-30T19:00:03Z
Lists: pgsql-novice
Thanks for the tip! On Sat, Nov 30, 2019 at 6:58 PM Bzzzz <lazyvirus@gmx.com> wrote: > On Sat, 30 Nov 2019 08:07:27 +0100 > Goke Aruna <goksie@gmail.com> wrote: > > > This is great, thank you! > > You're welcome. > > > Very educative. I am still reading on the zfs. > > From your explanation, you prefer software raid to hardware raid, > > though greater preference for ZFS. > > You can't really compare RAID to RAIDZ, they're different paradigms. > RAID is redundancy only, while RAIDZ is redundancy + data integrity. > > Of course, nothing comes without a cost (be it $$$ and/or speed) AND as > usual, YMMV from your own needs (an objective decision way it to make a > Ben (from Benjy Franklin): for each system, you take a sheet of paper, > separate it in 2 with a line, put positive points to the left and > negative to the right, balance them, add the points to see on which > side it is leaning AND respect this result (!).) > > > Do you have a pointer to what I can read on how this is achieved be it > > LVM or ZFS? > > Not really, I read a lot about that (hundreds of articles) before even > testing, so dig the web and read a lot - avoid old papers, as ZoL is > evolving quite fast. > > > By the way, based on your experience, what Linux variants will you > > recommend for postgresql and what version. > > Debian _stable_ is world's best (I'm a little biased on this one as I > use it for 20 years now;) > But not if you do not have very good administration skills and to also > be avoid if you want to boot your system on ZFS (which is not such a > good idea anyway.) > > > I have read from severalnines.com site that CentOS 7 should be avoided > > as much as possible unfortunately I am currently running it. > > Yeah, it is veeery baaad… compared to Debian ;-p) > No, it is indeed a good distro, as almost any other one that is a root > one ; it is also often used as a base for some applications on CD or live > CDz. > > If you don't know which one to pick, test them thoroughly one by one > taking your time (time only fully acknowledge things for which you took… > your time) - also take time to read articles and know if it's community's > large and alive (watch their mailing-lists archives, do they have a > large number of posts per month or not) and avoid derivatives (zzzzzz, > based upon aaaaaa.) > Take all your time, because your choice is something that'll almost > surely follow you for a looong time. > > Jean-Yves >