Re: Slow response to my query

From: Goke Aruna <goksie(at)gmail(dot)com>
To: Bzzzz <lazyvirus(at)gmx(dot)com>
Cc: Keith <keith(at)keithf4(dot)com>, Steven Pousty <steve(dot)pousty(at)gmail(dot)com>, pgsql-novice(at)lists(dot)postgresql(dot)org, Babatunde Adeyemi <barbietunnie(at)gmail(dot)com>
Subject: Re: Slow response to my query
Date: 2019-11-30 19:00:03
Message-ID: CAE=DitpOpm7KM+we4bvosgXN_qhkF0DsS3d4zpYu4p33hBAAAg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Thanks for the tip!

On Sat, Nov 30, 2019 at 6:58 PM Bzzzz <lazyvirus(at)gmx(dot)com> wrote:

> On Sat, 30 Nov 2019 08:07:27 +0100
> Goke Aruna <goksie(at)gmail(dot)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
>

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Dennis Suratna 2019-11-30 19:28:26 Re: Could not build from source /usr/bin/ld: cannot find -lpgcommon_shlib
Previous Message Tom Lane 2019-11-30 18:31:51 Re: Could not build from source /usr/bin/ld: cannot find -lpgcommon_shlib