Обсуждение: Best tools to monitor and fine tune postgres
Hi All,
Can someone please suggest some tools to monitor and tune postgres
Hi o1bigtenor,
Now what will you say about below query that he should have come with some research before asking here ?
On Friday, January 15, 2021, svsn raju <svsn2@yahoo.com> wrote:
On Friday, January 15, 2021, svsn raju <svsn2@yahoo.com> wrote:
Hi All,Can someone please suggest some tools to monitor and tune postgres
On Fri, Jan 15, 2021 at 8:56 AM Atul Kumar <akumar14871@gmail.com> wrote:
Hi o1bigtenor,Now what will you say about below query that he should have come with some research before asking here ?
Yes. The question gets asked frequently so if one searches the archive usually you'll get a thread from the past 6 months or so which is usually recent enough. Plus lots of people publish blog posts and articles on the topic, which are probably more well written and researched than off-the-cuff replies to a mailing list would be. At least posting "hey, I found these three tools, and am leaning toward such-and-such because of reasons, does anyone have any thoughts I should consider?" would should the effort and allow for better responses since at least some background is given. Knowing generally how the poster uses PostgreSQL also helps and should be included.
A posting like this I'll usually just ignore since I know that answers already exist to be found, and it is not something that I have chosen to become a "librarian/interactive assistant" for - I relegate to the documentation for that.
David J.
Again Thanks alot David for ur response.
You expect everyone to be perfect which cannot happen.
And related to thread, if someone has joined this thread today then it is obvious that he may not be able to find the previous threads as well.
Regards
Atul
On Friday, January 15, 2021, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Friday, January 15, 2021, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Fri, Jan 15, 2021 at 8:56 AM Atul Kumar <akumar14871@gmail.com> wrote:Hi o1bigtenor,Now what will you say about below query that he should have come with some research before asking here ?Yes. The question gets asked frequently so if one searches the archive usually you'll get a thread from the past 6 months or so which is usually recent enough. Plus lots of people publish blog posts and articles on the topic, which are probably more well written and researched than off-the-cuff replies to a mailing list would be. At least posting "hey, I found these three tools, and am leaning toward such-and-such because of reasons, does anyone have any thoughts I should consider?" would should the effort and allow for better responses since at least some background is given. Knowing generally how the poster uses PostgreSQL also helps and should be included.A posting like this I'll usually just ignore since I know that answers already exist to be found, and it is not something that I have chosen to become a "librarian/interactive assistant" for - I relegate to the documentation for that.David J.
Refer to this page for archives: https://www.postgresql.org/list/
On Fri, Jan 15, 2021 at 9:55 PM Atul Kumar <akumar14871@gmail.com> wrote:
Again Thanks alot David for ur response.You expect everyone to be perfect which cannot happen.And related to thread, if someone has joined this thread today then it is obvious that he may not be able to find the previous threads as well.RegardsAtul
On Friday, January 15, 2021, David G. Johnston <david.g.johnston@gmail.com> wrote:On Fri, Jan 15, 2021 at 8:56 AM Atul Kumar <akumar14871@gmail.com> wrote:Hi o1bigtenor,Now what will you say about below query that he should have come with some research before asking here ?Yes. The question gets asked frequently so if one searches the archive usually you'll get a thread from the past 6 months or so which is usually recent enough. Plus lots of people publish blog posts and articles on the topic, which are probably more well written and researched than off-the-cuff replies to a mailing list would be. At least posting "hey, I found these three tools, and am leaning toward such-and-such because of reasons, does anyone have any thoughts I should consider?" would should the effort and allow for better responses since at least some background is given. Knowing generally how the poster uses PostgreSQL also helps and should be included.A posting like this I'll usually just ignore since I know that answers already exist to be found, and it is not something that I have chosen to become a "librarian/interactive assistant" for - I relegate to the documentation for that.David J.
And basically you are improving your knowledge as you are expecting those questions the answers of which you dont know about.
On Friday, January 15, 2021, Atul Kumar <akumar14871@gmail.com> wrote:
Thats why you seem to not to be helpful and somehow stopping others to not to be helpful.
I don’t find find it wrong if any new guy asking the question that has been repeated 1000 times earlier, if I know the answer I WILL RESPOND 1000 TIMES, “unlike you”.
On Friday, January 15, 2021, Atul Kumar <akumar14871@gmail.com> wrote:
Again Thanks alot David for ur response.You expect everyone to be perfect which cannot happen.And related to thread, if someone has joined this thread today then it is obvious that he may not be able to find the previous threads as well.RegardsAtul
On Friday, January 15, 2021, David G. Johnston <david.g.johnston@gmail.com> wrote:On Fri, Jan 15, 2021 at 8:56 AM Atul Kumar <akumar14871@gmail.com> wrote:Hi o1bigtenor,Now what will you say about below query that he should have come with some research before asking here ?Yes. The question gets asked frequently so if one searches the archive usually you'll get a thread from the past 6 months or so which is usually recent enough. Plus lots of people publish blog posts and articles on the topic, which are probably more well written and researched than off-the-cuff replies to a mailing list would be. At least posting "hey, I found these three tools, and am leaning toward such-and-such because of reasons, does anyone have any thoughts I should consider?" would should the effort and allow for better responses since at least some background is given. Knowing generally how the poster uses PostgreSQL also helps and should be included.A posting like this I'll usually just ignore since I know that answers already exist to be found, and it is not something that I have chosen to become a "librarian/interactive assistant" for - I relegate to the documentation for that.David J.
People in any mailing lists are not free consultants. They expect their time to be valued and they expect the OP to at least do some research before posting
On Fri, Jan 15, 2021 at 9:56 PM Hemil Ruparel <hemilruparel2002@gmail.com> wrote:
Refer to this page for archives: https://www.postgresql.org/list/On Fri, Jan 15, 2021 at 9:55 PM Atul Kumar <akumar14871@gmail.com> wrote:Again Thanks alot David for ur response.You expect everyone to be perfect which cannot happen.And related to thread, if someone has joined this thread today then it is obvious that he may not be able to find the previous threads as well.RegardsAtul
On Friday, January 15, 2021, David G. Johnston <david.g.johnston@gmail.com> wrote:On Fri, Jan 15, 2021 at 8:56 AM Atul Kumar <akumar14871@gmail.com> wrote:Hi o1bigtenor,Now what will you say about below query that he should have come with some research before asking here ?Yes. The question gets asked frequently so if one searches the archive usually you'll get a thread from the past 6 months or so which is usually recent enough. Plus lots of people publish blog posts and articles on the topic, which are probably more well written and researched than off-the-cuff replies to a mailing list would be. At least posting "hey, I found these three tools, and am leaning toward such-and-such because of reasons, does anyone have any thoughts I should consider?" would should the effort and allow for better responses since at least some background is given. Knowing generally how the poster uses PostgreSQL also helps and should be included.A posting like this I'll usually just ignore since I know that answers already exist to be found, and it is not something that I have chosen to become a "librarian/interactive assistant" for - I relegate to the documentation for that.David J.
On Fri, Jan 15, 2021 at 9:58 PM Atul Kumar <akumar14871@gmail.com> wrote:
And basically you are improving your knowledge as you are expecting those questions the answers of which you dont know about.Thats why you seem to not to be helpful and somehow stopping others to not to be helpful.I don’t find find it wrong if any new guy asking the question that has been repeated 1000 times earlier, if I know the answer I WILL RESPOND 1000 TIMES, “unlike you”.
On Friday, January 15, 2021, Atul Kumar <akumar14871@gmail.com> wrote:Again Thanks alot David for ur response.You expect everyone to be perfect which cannot happen.And related to thread, if someone has joined this thread today then it is obvious that he may not be able to find the previous threads as well.RegardsAtul
On Friday, January 15, 2021, David G. Johnston <david.g.johnston@gmail.com> wrote:On Fri, Jan 15, 2021 at 8:56 AM Atul Kumar <akumar14871@gmail.com> wrote:Hi o1bigtenor,Now what will you say about below query that he should have come with some research before asking here ?Yes. The question gets asked frequently so if one searches the archive usually you'll get a thread from the past 6 months or so which is usually recent enough. Plus lots of people publish blog posts and articles on the topic, which are probably more well written and researched than off-the-cuff replies to a mailing list would be. At least posting "hey, I found these three tools, and am leaning toward such-and-such because of reasons, does anyone have any thoughts I should consider?" would should the effort and allow for better responses since at least some background is given. Knowing generally how the poster uses PostgreSQL also helps and should be included.A posting like this I'll usually just ignore since I know that answers already exist to be found, and it is not something that I have chosen to become a "librarian/interactive assistant" for - I relegate to the documentation for that.David J.
A quote from the aforementioned article. Do read. Worth your time
```
Hackers have a reputation for meeting simple questions with what looks like hostility or arrogance. It sometimes looks like we're reflexively rude to newbies and the ignorant. But this isn't really true.
What we are, unapologetically, is hostile to people who seem to be unwilling to think or to do their own homework before asking questions. People like that are time sinks — they take without giving back, and they waste time we could have spent on another question more interesting and another person more worthy of an answer. We call people like this “losers” (and for historical reasons we sometimes spell it “lusers”).
```
On Fri, Jan 15, 2021 at 10:01 PM Hemil Ruparel <hemilruparel2002@gmail.com> wrote:
On Fri, Jan 15, 2021 at 9:58 PM Atul Kumar <akumar14871@gmail.com> wrote:And basically you are improving your knowledge as you are expecting those questions the answers of which you dont know about.Thats why you seem to not to be helpful and somehow stopping others to not to be helpful.I don’t find find it wrong if any new guy asking the question that has been repeated 1000 times earlier, if I know the answer I WILL RESPOND 1000 TIMES, “unlike you”.
On Friday, January 15, 2021, Atul Kumar <akumar14871@gmail.com> wrote:Again Thanks alot David for ur response.You expect everyone to be perfect which cannot happen.And related to thread, if someone has joined this thread today then it is obvious that he may not be able to find the previous threads as well.RegardsAtul
On Friday, January 15, 2021, David G. Johnston <david.g.johnston@gmail.com> wrote:On Fri, Jan 15, 2021 at 8:56 AM Atul Kumar <akumar14871@gmail.com> wrote:Hi o1bigtenor,Now what will you say about below query that he should have come with some research before asking here ?Yes. The question gets asked frequently so if one searches the archive usually you'll get a thread from the past 6 months or so which is usually recent enough. Plus lots of people publish blog posts and articles on the topic, which are probably more well written and researched than off-the-cuff replies to a mailing list would be. At least posting "hey, I found these three tools, and am leaning toward such-and-such because of reasons, does anyone have any thoughts I should consider?" would should the effort and allow for better responses since at least some background is given. Knowing generally how the poster uses PostgreSQL also helps and should be included.A posting like this I'll usually just ignore since I know that answers already exist to be found, and it is not something that I have chosen to become a "librarian/interactive assistant" for - I relegate to the documentation for that.David J.
On Fri, Jan 15, 2021 at 9:25 AM Atul Kumar <akumar14871@gmail.com> wrote:
You expect everyone to be perfect which cannot happen.And related to thread, if someone has joined this thread today then it is obvious that he may not be able to find the previous threads as well.
The quality of a response is pretty highly positively correlated to the quality of the request. I don't expect people to be perfect, I'm just describing those things that increase request quality.
"Being able to demonstrate being able to locate existing information" isn't a prerequisite for receiving a response, but I also don't feel bad when I don't respond because of the lack, or when my response is to point people to that already existing information.
David J.
On Fri, Jan 15, 2021 at 9:28 AM Atul Kumar <akumar14871@gmail.com> wrote:
I don’t find find it wrong if any new guy asking the question that has been repeated 1000 times earlier, if I know the answer I WILL RESPOND 1000 TIMES, “unlike you”.
At some point that becomes both personally disruptive and bad for the community. Intentionally not answering and letting someone else answer (this being a public forum) is how other members of the community will end up growing. If you answer questions well beneath your capabilities you don't grow while someone else, who is a bit uncertain, giving the same response, will receive positive feedback when their same answer is shown to be correct. And given the safety net of others chiming in for incorrect (or incomplete) answers it is a safe forum in which to do those kinds of things. If anything giving honest but wrong answers and receiving corrective comments is a virtue of this community.
David J.
On 1/15/21 7:37 AM, svsn raju wrote: > Hi All, > > Can someone please suggest some tools to monitor and tune postgres Postgres numeric version? Community version, forked version, cloud version(e.g. AWS)? OS and version you will be running tools on? > > > Sent from Yahoo Mail on Android > <https://go.onelink.me/107872968?pid=InProduct&c=Global_Internal_YGrowth_AndroidEmailSig__AndroidUsers&af_wl=ym&af_sub1=Internal&af_sub2=Global_YGrowth&af_sub3=EmailSignature> -- Adrian Klaver adrian.klaver@aklaver.com
Yes you are right. And it seems for those that ignore queries to answer.
Your mates have already said that they ignore answering repeated questions.
On Friday, January 15, 2021, Hemil Ruparel <hemilruparel2002@gmail.com> wrote:
On Friday, January 15, 2021, Hemil Ruparel <hemilruparel2002@gmail.com> wrote:
On Fri, Jan 15, 2021 at 9:58 PM Atul Kumar <akumar14871@gmail.com> wrote:And basically you are improving your knowledge as you are expecting those questions the answers of which you dont know about.Thats why you seem to not to be helpful and somehow stopping others to not to be helpful.I don’t find find it wrong if any new guy asking the question that has been repeated 1000 times earlier, if I know the answer I WILL RESPOND 1000 TIMES, “unlike you”.
On Friday, January 15, 2021, Atul Kumar <akumar14871@gmail.com> wrote:Again Thanks alot David for ur response.You expect everyone to be perfect which cannot happen.And related to thread, if someone has joined this thread today then it is obvious that he may not be able to find the previous threads as well.RegardsAtul
On Friday, January 15, 2021, David G. Johnston <david.g.johnston@gmail.com> wrote:On Fri, Jan 15, 2021 at 8:56 AM Atul Kumar <akumar14871@gmail.com> wrote:Hi o1bigtenor,Now what will you say about below query that he should have come with some research before asking here ?Yes. The question gets asked frequently so if one searches the archive usually you'll get a thread from the past 6 months or so which is usually recent enough. Plus lots of people publish blog posts and articles on the topic, which are probably more well written and researched than off-the-cuff replies to a mailing list would be. At least posting "hey, I found these three tools, and am leaning toward such-and-such because of reasons, does anyone have any thoughts I should consider?" would should the effort and allow for better responses since at least some background is given. Knowing generally how the poster uses PostgreSQL also helps and should be included.A posting like this I'll usually just ignore since I know that answers already exist to be found, and it is not something that I have chosen to become a "librarian/interactive assistant" for - I relegate to the documentation for that.David J.
On 1/15/21 8:44 AM, Atul Kumar wrote: > Yes you are right. And it seems for those that ignore queries to answer. I am not following what you are trying to say above? > > Your mates have already said that they ignore answering repeated questions. > -- Adrian Klaver adrian.klaver@aklaver.com
On 1/15/21 8:28 AM, Atul Kumar wrote: > And basically you are improving your knowledge as you are expecting > those questions the answers of which you dont know about. > > Thats why you seem to not to be helpful and somehow stopping others to > not to be helpful. > > I don’t find find it wrong if any new guy asking the question that has > been repeated 1000 times earlier, if I know the answer I WILL RESPOND > 1000 TIMES, “unlike you”. > It was for this reason that FAQ's(https://wiki.postgresql.org/wiki/FAQ) where created. Also why the mailing list archives are searchable: https://www.postgresql.org/search/?m=1&ln=pgsql-general&q=monitor+tool Which leads to: https://www.postgresql.org/message-id/CAODZiv7LE+OAwpTyA8G6vBd0gGmRwfrP1X0JXs5wvAuorENxrg@mail.gmail.com https://www.postgresql.org/message-id/20200528091111.mog2nxiyuan7xjjy%40office.hexack.fr The frustration is that with literally a world of information at hand and searchable, folks often do not do the basic homework that would answer their question in less time then waiting for a response from a list. You see it enough times and even the calmest person gets irritated. In a perfect world that would not happen, we don't live in a perfect world. -- Adrian Klaver adrian.klaver@aklaver.com
You keep on giving excuses (imperfect world and blah blah) and I will keep on raising questions on them.
On Saturday, January 16, 2021, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
The link you shared could have been shared earlier as well.
But instead of that as usual you and your mates stretched the conversation without going in any direction so basically you wasted author’s time.
And I have no doubt that you will waste more time of yours as well as of us by giving some kore excuses.
On Saturday, January 16, 2021, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 1/15/21 8:28 AM, Atul Kumar wrote:And basically you are improving your knowledge as you are expecting those questions the answers of which you dont know about.
Thats why you seem to not to be helpful and somehow stopping others to not to be helpful.
I don’t find find it wrong if any new guy asking the question that has been repeated 1000 times earlier, if I know the answer I WILL RESPOND 1000 TIMES, “unlike you”.
It was for this reason that FAQ's(https://wiki.postgresql.org/wiki/FAQ) where created. Also why the mailing list archives are searchable:
https://www.postgresql.org/search/?m=1&ln=pgsql-general&q= monitor+tool
Which leads to:
https://www.postgresql.org/message-id/CAODZiv7LE+OAwpTyA8G6v Bd0gGmRwfrP1X0JXs5wvAuorENxrg@ mail.gmail.com
https://www.postgresql.org/message-id/20200528091111.mog2nxi yuan7xjjy%40office.hexack.fr
The frustration is that with literally a world of information at hand and searchable, folks often do not do the basic homework that would answer their question in less time then waiting for a response from a list. You see it enough times and even the calmest person gets irritated. In a perfect world that would not happen, we don't live in a perfect world.
--
Adrian Klaver
adrian.klaver@aklaver.com
This conversation doesn't really have anything to do with monitoring and fine-tuning PostgreSQL, at this point, does it? It might be appropriate to let go the meta-discussion when each individual person thinks it is appropriate to answera question. -- -- Christophe Pettus xof@thebuild.com
On Fri, Jan 15, 2021 at 1:53 PM Christophe Pettus <xof@thebuild.com> wrote:
This conversation doesn't really have anything to do with monitoring and fine-tuning PostgreSQL, at this point, does it? It might be appropriate to let go the meta-discussion when each individual person thinks it is appropriate to answer a question.
Actually, on the whole it is admirably on-topic as to how what seems like such a simple question from a newcomer's perspective is perceived by those on the list to whom that question is being posed. With a number of the responses giving indirect answers to the question since it, as has been established, is a common question with answers available from sources other than volunteers writing new emails or searching themselves for old replies.
On a thread of interest to newcomers it seems like a reasonably productive spot to describe the reality, which is what is being done here - not providing excuses. We aren't apologetic for these realities, while understanding that improvement is possible (if hard to achieve - technical and personal).
David J.
On 1/15/21 12:50 PM, Atul Kumar wrote: > You keep on giving excuses (imperfect world and blah blah) and I will > keep on raising questions on them. They are not excuses they are explaining the reality of the situation. This is a list of people taking time out of their day to answer questions. They receive no direct payment(though many are probably doing it on the clock of their employer) for this, so the motivation to answer is personal. That motivation may not cover questions they have answered many times and/or questions that are content free. At that point the questioner has to either wait for someone with the motivation or do some leg work to make the question more appealing. That is just how it is. The other option is to provide monetary motivation and buy responses from one of the many companies that offer that service: https://www.postgresql.org/support/professional_support/ > > And I have no doubt that you will waste more time of yours as well as of > us by giving some kore excuses. > This post marks the end of my wasting your time. -- Adrian Klaver adrian.klaver@aklaver.com
If you want answers everytime no matter how stupid they are, my price is $40/hour. We can negotiate how much of my time you are allowed to waste. This is my personal time I am spending on replying. Plus, you are probably working for a company which uses postgres but doesn't even care to provide proper training to its employees let alone fund the development of postgres. We are under no obligation to reply to you. Neither do you respect our time and effort.
On Sat, Jan 16, 2021 at 3:27 AM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 1/15/21 12:50 PM, Atul Kumar wrote:
> You keep on giving excuses (imperfect world and blah blah) and I will
> keep on raising questions on them.
They are not excuses they are explaining the reality of the situation.
This is a list of people taking time out of their day to answer
questions. They receive no direct payment(though many are probably doing
it on the clock of their employer) for this, so the motivation to answer
is personal. That motivation may not cover questions they have answered
many times and/or questions that are content free. At that point the
questioner has to either wait for someone with the motivation or do some
leg work to make the question more appealing. That is just how it is.
The other option is to provide monetary motivation and buy responses
from one of the many companies that offer that service:
https://www.postgresql.org/support/professional_support/
>
> And I have no doubt that you will waste more time of yours as well as of
> us by giving some kore excuses.
>
This post marks the end of my wasting your time.
--
Adrian Klaver
adrian.klaver@aklaver.com