Best tools to monitor and fine tune postgres
Hi All,
Can someone please suggest some tools to monitor and tune postgres
Sent from Yahoo Mail on Android
Import Notes
Reference msg id not found: 937655834.1614113.1610725029956.ref@mail.yahoo.com
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:
Show quoted text
Hi All,
Can someone please suggest some tools to monitor and tune postgres
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>
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:
Show quoted text
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:
Show quoted text
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
AtulOn 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.
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:
Show quoted text
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
AtulOn 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:
Show quoted text
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.Regards
AtulOn 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.
http://catb.org/~esr/faqs/smart-questions.html
On Fri, Jan 15, 2021 at 9:58 PM Atul Kumar <akumar14871@gmail.com> wrote:
Show quoted text
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.Regards
AtulOn 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:
Show quoted text
http://catb.org/~esr/faqs/smart-questions.html
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.Regards
AtulOn 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:
Show quoted text
http://catb.org/~esr/faqs/smart-questions.html
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.Regards
AtulOn 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:
/messages/by-id/CAODZiv7LE+OAwpTyA8G6vBd0gGmRwfrP1X0JXs5wvAuorENxrg@mail.gmail.com
/messages/by-id/20200528091111.mog2nxiyuan7xjjy@office.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.
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:
Show quoted text
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:
/messages/by-id/CAODZiv7LE+OAwpTyA8G6v
Bd0gGmRwfrP1X0JXs5wvAuorENxrg@mail.gmail.com/messages/by-id/20200528091111.mog2nxi
yuan7xjjy%40office.hexack.frThe 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 answer a 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:
Show quoted text
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