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
>