Re: Slow response to my query

Goke Aruna <[email protected]> Sat, 30 Nov 2019 20:00:03 +0100
Newsgroups gmane.comp.db.postgresql.novice
Message-ID <CAE=DitpOpm7KM+we4bvosgXN_qhkF0DsS3d4zpYu4p33hBAAAg@mail.gmail.com>
--000000000000066d00059894f533
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Thanks for the tip!

On Sat, Nov 30, 2019 at 6:58 PM Bzzzz <[email protected]> wrote:

> On Sat, 30 Nov 2019 08:07:27 +0100
> Goke Aruna <[email protected]> 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=E2=80=A6 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=
=E2=80=A6
> 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
>

--000000000000066d00059894f533
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Thanks for the tip! <br></div><br><div class=3D"gmail_quot=
e"><div dir=3D"ltr" class=3D"gmail_attr">On Sat, Nov 30, 2019 at 6:58 PM Bz=
zzz &lt;<a href=3D"mailto:[email protected]">[email protected]</a>&gt; wrot=
e:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0=
.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">On Sat, 30 No=
v 2019 08:07:27 +0100<br>
Goke Aruna &lt;<a href=3D"mailto:[email protected]" target=3D"_blank">goksie=
@gmail.com</a>&gt; wrote:<br>
<br>
&gt; This is great, thank you!<br>
<br>
You&#39;re welcome.<br>
<br>
&gt; Very educative. I am still reading on the zfs.<br>
&gt; From your explanation, you prefer software raid to hardware raid,<br>
&gt; though greater preference for ZFS.<br>
<br>
You can&#39;t really compare RAID to RAIDZ, they&#39;re different paradigms=
.<br>
RAID is redundancy only, while RAIDZ is redundancy + data integrity.<br>
<br>
Of course, nothing comes without a cost (be it $$$ and/or speed) AND as<br>
usual, YMMV from your own needs (an objective decision way it to make a<br>
Ben (from Benjy Franklin): for each system, you take a sheet of paper,<br>
separate it in 2 with a line, put positive points to the left and<br>
negative to the right, balance them, add the points to see on which<br>
side it is leaning AND respect this result (!).)<br>
<br>
&gt; Do you have a pointer to what I can read on how this is achieved be it=
<br>
&gt; LVM or ZFS?<br>
<br>
Not really, I read a lot about that (hundreds of articles) before even<br>
testing, so dig the web and read a lot - avoid old papers, as ZoL is<br>
evolving quite fast.<br>
<br>
&gt; By the way, based on your experience, what Linux variants will you<br>
&gt; recommend for postgresql and what version.<br>
<br>
Debian _stable_ is world&#39;s best (I&#39;m a little biased on this one as=
 I<br>
use it for 20 years now;)<br>
But not if you do not have very good administration skills and to also<br>
be avoid if you want to boot your system on ZFS (which is not such a<br>
good idea anyway.)<br>
<br>
&gt; I have read from <a href=3D"http://severalnines.com" rel=3D"noreferrer=
" target=3D"_blank">severalnines.com</a> site that CentOS 7 should be avoid=
ed<br>
&gt; as much as possible unfortunately I am currently running it.<br>
<br>
Yeah, it is veeery baaad=E2=80=A6 compared to Debian ;-p)<br>
No, it is indeed a good distro, as almost any other one that is a root<br>
one ; it is also often used as a base for some applications on CD or live<b=
r>
CDz.<br>
<br>
If you don&#39;t know which one to pick, test them thoroughly one by one<br=
>
taking your time (time only fully acknowledge things for which you took=E2=
=80=A6<br>
your time) - also take time to read articles and know if it&#39;s community=
&#39;s<br>
large and alive (watch their mailing-lists archives, do they have a<br>
large number of posts per month or not) and avoid derivatives (zzzzzz,<br>
based upon aaaaaa.)<br>
Take all your time, because your choice is something that&#39;ll almost<br>
surely follow you for a looong time.<br>
<br>
Jean-Yves<br>
</blockquote></div>

--000000000000066d00059894f533--