Re: Slow response to my query - Mailing list pgsql-novice

From Bzzzz
Subject Re: Slow response to my query
Date
Msg-id 20191130185835.5c385269@msi.defcon1.lan
Whole thread Raw
In response to Re: Slow response to my query  (Goke Aruna <goksie@gmail.com>)
Responses Re: Slow response to my query
List pgsql-novice
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



pgsql-novice by date:

Previous
From: Dennis Suratna
Date:
Subject: Could not build from source /usr/bin/ld: cannot find -lpgcommon_shlib
Next
From: Tom Lane
Date:
Subject: Re: Could not build from source /usr/bin/ld: cannot find -lpgcommon_shlib