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 <<a href=3D"mailto:[email protected]">[email protected]</a>> 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 <<a href=3D"mailto:[email protected]" target=3D"_blank">goksie= @gmail.com</a>> wrote:<br> <br> > This is great, thank you!<br> <br> You're welcome.<br> <br> > Very educative. I am still reading on the zfs.<br> > From your explanation, you prefer software raid to hardware raid,<br> > though greater preference for ZFS.<br> <br> You can't really compare RAID to RAIDZ, they'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> > Do you have a pointer to what I can read on how this is achieved be it= <br> > 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> > By the way, based on your experience, what Linux variants will you<br> > recommend for postgresql and what version.<br> <br> Debian _stable_ is world's best (I'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> > 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> > 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'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's community= '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'll almost<br> surely follow you for a looong time.<br> <br> Jean-Yves<br> </blockquote></div> --000000000000066d00059894f533--