Re: Do we need a way to moderate mailing lists?

In my frustration* On Sat, Jan 16, 2021 at 1:24 PM Hemil Ruparel wrote: > In my furstration, I never thought about the self moderation effect. > Thanks Tim > > On Sat, Jan 16, 2021 at 1:14 PM Tim Cross wrote: > >> >> Hemil Ruparel writes: >> >> > Exactly my point. We need to raise the bar of t

Re: Do we need a way to moderate mailing lists?

In my furstration, I never thought about the self moderation effect. Thanks Tim On Sat, Jan 16, 2021 at 1:14 PM Tim Cross wrote: > > Hemil Ruparel writes: > > > Exactly my point. We need to raise the bar of the behavior we tolerate. > > This should not be tolerated. We need to set an example. T

Re: Do we need a way to moderate mailing lists?

Okay. I will not reply to them. Enough mental cycles wasted On Sat, Jan 16, 2021 at 1:11 PM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Friday, January 15, 2021, Hemil Ruparel > wrote: > >> I am not asking people to get banned the moment they ask easy questions. >> I am 18. Belie

Re: Do we need a way to moderate mailing lists?

Hemil Ruparel writes: > Exactly my point. We need to raise the bar of the behavior we tolerate. > This should not be tolerated. We need to set an example. The person in > question clearly understood english and I have never seen a person who > could use mailing lists but not google. So that's o

Re: Do we need a way to moderate mailing lists?

On Friday, January 15, 2021, Hemil Ruparel wrote: > I am not asking people to get banned the moment they ask easy questions. I > am 18. Believe me I have done that too (way more than i would like to admit > ;P). I am just saying we should guide them. But there are some people who > do not wish to

Re: Do we need a way to moderate mailing lists?

I am not asking people to get banned the moment they ask easy questions. I am 18. Believe me I have done that too (way more than i would like to admit ;P). I am just saying we should guide them. But there are some people who do not wish to be guided. They just want spoonfed answers which is untoler

Re: Do we need a way to moderate mailing lists?

On Friday, January 15, 2021, Christophe Pettus wrote: > > > > On Jan 15, 2021, at 22:19, Hemil Ruparel > wrote: > > > > I have no problems if there are one or two questions which are exactly > the same. I give them the benefit of doubt. What I won't tolerate are > entitled people who think we wo

Re: Do we need a way to moderate mailing lists?

To pick up Pettus's point: filtering out precisely and only the noise is hard.  Maybe in a couple more decades we'll be there.  (Sorry I won't be around for it.) For now ignoring it might be the best option. On 1/15/21 11:43 PM, Hemil Ruparel wrote: Exactly my point. We need to raise the bar of

Re: Do we need a way to moderate mailing lists?

Exactly my point. We need to raise the bar of the behavior we tolerate. This should not be tolerated. We need to set an example. The person in question clearly understood english and I have never seen a person who could use mailing lists but not google. So that's out of the question. We are not fr

Re: Do we need a way to moderate mailing lists?

I watched this sadness play out.  It had nothing to do with the OP's original question. Rather someone with feelings hurt from a separate thread (table correlation) felt the need drag that squabble over to the focal issue here (tools).  I was tempted bring up the COC but I'm not really a believ

Re: Do we need a way to moderate mailing lists?

I agree. That's why I proposed to guide such people as the first attempt giving them the benefit of the doubt. On Sat, Jan 16, 2021 at 11:52 AM Christophe Pettus wrote: > > > > On Jan 15, 2021, at 22:19, Hemil Ruparel > wrote: > > > > I have no problems if there are one or two questions which a

Re: Do we need a way to moderate mailing lists?

> On Jan 15, 2021, at 22:19, Hemil Ruparel wrote: > > I have no problems if there are one or two questions which are exactly the > same. I give them the benefit of doubt. What I won't tolerate are entitled > people who think we work for them for free and that they are entitled to > receive

Re: Do we need a way to moderate mailing lists?

I have no problems if there are one or two questions which are exactly the same. I give them the benefit of doubt. What I won't tolerate are entitled people who think we work for them for free and that they are entitled to receive and answer. On Sat, Jan 16, 2021 at 11:45 AM Christophe Pettus wro

Re: Do we need a way to moderate mailing lists?

> On Jan 15, 2021, at 22:10, Hemil Ruparel wrote: > > I fear that mailing lists become like quora. pgsql-general is almost old enough to drink. :) The very first message I could find with a reliable date is from 31 May 2000. I think after nearly 21 years, we don't have much to worry about

Re: Do we need a way to moderate mailing lists?

I fear that mailing lists become like quora. Eternal September was probably the first time this happened. History repeats itself. I don't want the community to lose its value On Sat, Jan 16, 2021 at 11:37 AM Christophe Pettus wrote: > > > > On Ja

Re: Do we need a way to moderate mailing lists?

> On Jan 15, 2021, at 21:51, Hemil Ruparel wrote: > It's my personal opinion. But i personally do not want to deal with entitled > people who cannot do basic google searches. Well, I have to mention that you don't have to deal with them. It might be slightly irritating to read questions lik

Re: Do we need a way to moderate mailing lists?

I will send them a mail anyway. Lets see their response On Sat, Jan 16, 2021 at 11:30 AM Hemil Ruparel wrote: > I don't know on what basis should the complaint be made other than the > peron's entitlement > > On Sat, Jan 16, 2021 at 11:24 AM Christophe Pettus > wrote: > >> >> >> > On Jan 15, 20

Re: Do we need a way to moderate mailing lists?

I don't know on what basis should the complaint be made other than the peron's entitlement On Sat, Jan 16, 2021 at 11:24 AM Christophe Pettus wrote: > > > > On Jan 15, 2021, at 21:51, Hemil Ruparel > wrote: > > > > This is a meta discussion. I couldn't find a meta mailing list so I am > posting

Re: Do we need a way to moderate mailing lists?

> On Jan 15, 2021, at 21:51, Hemil Ruparel wrote: > > This is a meta discussion. I couldn't find a meta mailing list so I am > posting it here. This discussion sparked from this message. If you feel someone is being disruptive, or abusive, there is a Code of Conduct process: https

Do we need a way to moderate mailing lists?

This is a meta discussion. I couldn't find a meta mailing list so I am posting it here. This discussion sparked from this message . We should clearly mention on the postgres ma

Re: Best tools to monitor and fine tune postgres

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 pro

couldn't drop subscription after upgrading via logical replication.

Hello! I upgraded my postgres from 11 to 13 using logical replication(publication in PG-11 and subscription in PG-13 of course). Now I encountered this problem, I cannot drop the subscription in PG-13: drop subscription sub_upgrade_to_13; ERROR:  could not drop the replication slot "sub_upgrad

Re: PostgreSQL License Question

On 1/15/21 6:35 AM, Kristi Kangas wrote: Hello,  I see on your website that PostgreSQL is released under an Open Source license.  Do you consider addendums proposed by your users, modifying the posted license terms? I believe that is answered further down on the page: "Will PostgreSQL e

PostgreSQL License Question

Hello, I see on your website that PostgreSQL is released under an Open Source license. Do you consider addendums proposed by your users, modifying the posted license terms? Thank you. From your website: PostgreSQL is released under the PostgreSQL License

Re: Accounting for between table correlation

On Fri, Jan 15, 2021 at 12:27 PM Michael Lewis wrote: > On Fri, Jan 15, 2021 at 10:22 AM Alexander Stoddard < > alexander.stodd...@gmail.com> wrote: > >> The 'fast plans' use parallel seq scans. The 'slow plans' is using index >> scans. It appears a good query plan correctly predicts it should be

Re: Best tools to monitor and fine tune postgres

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. The

Re: Accounting for between table correlation

On 1/15/21 11:54 AM, Adrian Klaver wrote: On 1/15/21 10:49 AM, Alexander Stoddard wrote: Please reply to list also. Ccing list.     So to be clear, the process imports the data, then you run a query and     it completes in x time, you then ANALYZE the same data and it runs in y     time. I

Re: time-based range partitioning and truncate/delete different timezones

Fra: Michael Lewis Dato: 15. januar 2021 kl. 19.49.32 CET Til: Niels Jespersen Cc: pgsql-gene...@postgresql.org Emne: Re: time-based range partitioning and truncate/delete different timezones What version are you using? How long are you keeping data for? It

Re: Best tools to monitor and fine tune postgres

On Fri, Jan 15, 2021 at 1:53 PM Christophe Pettus 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

Re: Best tools to monitor and fine tune postgres

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 x...@thebuild.com

Re: Best tools to monitor and fine tune postgres

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 a

Re: Best tools to monitor and fine tune postgres

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

Re: Accounting for between table correlation

On 1/15/21 10:49 AM, Alexander Stoddard wrote: Please reply to list also. Ccing list. So to be clear, the process imports the data, then you run a query and it completes in x time, you then ANALYZE the same data and it runs in y time. Is that correct? The process imports data, ANA

Re: migration from postgres to enterprosedb

You'd probably get more response if you gave more info on your situation and what you have already come up with as a tentative approach- how much data in your 9.5 instance, what OS, what is acceptable downtime, etc. Regardless, do you mean EDB Postgres Advanced Server or just one of the installers

Re: time-based range partitioning and truncate/delete different timezones

What version are you using? How long are you keeping data for? It is possible to partition by hour or would that exceed the number of recommended partitions too quickly for your retention time period? Else, I would partition on date according to the timezone of your data. Selecting from multiple pa

Re: Accounting for between table correlation

On Fri, Jan 15, 2021 at 9:10 AM Thomas Kellerer wrote: > Maybe there are many "idle in transaction" sessions that prevent > autovacuum from properly > analyzing those tables. Or maybe for some unknown reason autovacuum was > turned off. > Or maybe they receive a lot of bulk loads which would requ

Re: Accounting for between table correlation

On Fri, Jan 15, 2021 at 10:22 AM Alexander Stoddard < alexander.stodd...@gmail.com> wrote: > The 'fast plans' use parallel seq scans. The 'slow plans' is using index > scans. It appears a good query plan correctly predicts it should be bulk > processing the tables but bad ones get fooled into tras

Re: Best tools to monitor and fine tune postgres

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.kla...@aklaver.com

Re: Accounting for between table correlation

On 1/15/21 9:21 AM, Alexander Stoddard wrote: Unfortunately I'm not free to share the specific schema or the query plans. They derive from an upstream vendor that is 'protective' of their data model. To get to a proper example I'll need to recreate the behavior with generic data in a generified

Re: Accounting for between table correlation

Unfortunately I'm not free to share the specific schema or the query plans. They derive from an upstream vendor that is 'protective' of their data model. To get to a proper example I'll need to recreate the behavior with generic data in a generified schema. I apologize for being frustratingly vagu

Re: Best tools to monitor and fine tune postgres

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 wrote: > http://catb.org/~esr/faqs/smart-questions.html > > On Fri, Jan 15, 2021 at 9:58 PM Atul Kumar

Re: Best tools to monitor and fine tune postgres

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

Re: Best tools to monitor and fine tune postgres

On Fri, Jan 15, 2021 at 9:28 AM Atul Kumar 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 c

Re: Best tools to monitor and fine tune postgres

On Fri, Jan 15, 2021 at 9:25 AM Atul Kumar 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 h

Re: Best tools to monitor and fine tune postgres

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, unapologe

Re: Best tools to monitor and fine tune postgres

http://catb.org/~esr/faqs/smart-questions.html On Fri, Jan 15, 2021 at 9:58 PM 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 othe

Re: Best tools to monitor and fine tune postgres

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 wrote: > Refer to this page for archives: https://www.postgresql.org/list/ > > On Fri, Jan 15

Re: Best tools to monitor and fine tune postgres

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 repea

Re: Best tools to monitor and fine tune postgres

Refer to this page for archives: https://www.postgresql.org/list/ On Fri, Jan 15, 2021 at 9:55 PM Atul Kumar 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

Re: Accounting for between table correlation

On Fri, Jan 15, 2021 at 9:10 AM Thomas Kellerer wrote: > Atul Kumar schrieb am 15.01.2021 um 16:29: > > As per Ron, you are not supposed to ask your questions here. > > > > As According to him, we should keep on doing research on internet > > rather than asking for support directly even you have

Re: Best tools to monitor and fine tune postgres

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. J

Re: ldap connection parameter lookup

On Fri, 2021-01-15 at 14:09 +, Zwettler Markus (OIZ) wrote: > I want to use ldap to lookup the connection parameters: > https://www.postgresql.org/docs/12/libpq-ldap.html > > > Do I have to create one static entry per database within pg_service.conf like: > > [mydatabase] > ldap://ldap.m

Re: Accounting for between table correlation

Atul Kumar schrieb am 15.01.2021 um 16:29: As per Ron, you are not supposed to ask your questions here. As According to him, we should keep on doing research on internet rather than asking for support directly even you have done enough research and until unless “Ron” won’t be satisfied you have

Re: Best tools to monitor and fine tune postgres

On Fri, Jan 15, 2021 at 8:56 AM Atul Kumar 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

Re: Best tools to monitor and fine 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 wrote: > Hi All, > > Can someone please suggest some tools to monitor and tune postgres > > > Sent from Yahoo Mail on Android >

Re: Accounting for between table correlation

On Fri, Jan 15, 2021 at 8:44 AM Atul Kumar wrote: > Hi Ron, > > I have a simple mindset that If I don’t know about something about > anyone’s query I don’t respond. > > Please start learning to not to interrupt or raising useless questions/ > phrases on someone’s query bcz it makes you judgementa

Re: Accounting for between table correlation

Hi Ron, I have a simple mindset that If I don’t know about something about anyone’s query I don’t respond. Please start learning to not to interrupt or raising useless questions/ phrases on someone’s query bcz it makes you judgemental. So please take an advice to not to interrupt if you can’t he

Re: Accounting for between table correlation

On Fri, Jan 15, 2021 at 9:29 AM Atul Kumar wrote: > > Hi Alexander, > > As per Ron, you are not supposed to ask your questions here. > > As According to him, we should keep on doing research on internet rather than > asking for support directly even you have done enough research and until > unle

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

Re: upgrade postgres 9.5 to 9.6

On 1/15/21 9:17 AM, Thomas Kellerer wrote: [snip] Is there a reason you are upgrading to 9.6 and not 12 or 13? The application software vendor might only certify the application on 9.6. Or /management/, in their infinite "wisdom", might insist on a One-version upgrade. Or 9.6 might be the defa

Re: Accounting for between table correlation

Hi Alexander, As per Ron, you are not supposed to ask your questions here. As According to him, we should keep on doing research on internet rather than asking for support directly even you have done enough research and until unless “Ron” won’t be satisfied you have to do keep on researching.

Re: Accounting for between table correlation

On 1/15/21 9:19 AM, Alexander Stoddard wrote: I am having ongoing trouble with a pair of tables, the design of which is beyond my control. There is a 'primary' table with hundreds of millions of rows. There is then a 'subclass' table ~ 10% of the primary which has additional fields. The table

Accounting for between table correlation

I am having ongoing trouble with a pair of tables, the design of which is beyond my control. There is a 'primary' table with hundreds of millions of rows. There is then a 'subclass' table ~ 10% of the primary which has additional fields. The tables logically share a primary key field (although tha

Re: upgrade postgres 9.5 to 9.6

Atul Kumar schrieb am 15.01.2021 um 14:17: > I want to upgrade my server from postgres 9.5 to 9.6, but my DB size > is in TBs and I want to do it in minimum downtime (2-3 hours) so > please help me how should I perform it. > > > Please share the document, if possible, it will be grateful. pg_upgra

Re: could not fsync file ""pg_wal/xlogtemp.23229"": Input/output error

Fix it already, so it was the SAN and vmware issue. Thanks Everyone. On Fri, Jan 15, 2021 at 4:40 PM Soni M wrote: > More disk space now available, but still the error happens and postgres > won't start. > I think it could be corrupted shared buffers, as stated on the log > messages, and perhap

Re: upgrade postgres 9.5 to 9.6

May you provide me steps to perform it (logical replication upgrade). I will be thankful to you. Regards Atul On Friday, January 15, 2021, Enrico Pirozzi wrote: > Hi Atul, > you could use logical replication and do an hot upgrade between the 2 > servers with a zero downtime ;) > > If you wa

ldap connection parameter lookup

Hi, I want to use ldap to lookup the connection parameters: https://www.postgresql.org/docs/12/libpq-ldap.html Do I have to create one static entry per database within pg_service.conf like: [mydatabase] ldap://ldap.mycompany.com/dc=mycompany,dc=com?description?one?(cn=mydatabase) or is there

Re: upgrade postgres 9.5 to 9.6

Hi Atul, you could use logical replication and do an hot upgrade between the 2 servers with a zero downtime ;) If you want to use logical replication between a 9.5 , 9.6 version you could use for example pglogical. You could achieve the same result using an external logic replication tool like

upgrade postgres 9.5 to 9.6

Hi, I want to upgrade my server from postgres 9.5 to 9.6, but my DB size is in TBs and I want to do it in minimum downtime (2-3 hours) so please help me how should I perform it. Please share the document, if possible, it will be grateful. Regards, Atul

migration from postgres to enterprosedb

Hi, I have postgres setup of having version postgres 9.5 and I want to migrate it to enterprisedb 10. So Please help me for the same as I am newbee for postgres migration. Regards, Atul

time-based range partitioning and truncate/delete different timezones

Hi all I need ideas regarding a way to design an insert, truncate/delete, and reinsert process on data that is in UTC and database range partitions that are in the Europe/Brussels time zone. Therefore, any input is welcome. The issue at hand is this. We receive daily file deliveries of time-ba

Re: could not fsync file ""pg_wal/xlogtemp.23229"": Input/output error

More disk space now available, but still the error happens and postgres won't start. I think it could be corrupted shared buffers, as stated on the log messages, and perhaps the corruption goes to disk. On Fri, Jan 15, 2021 at 4:33 PM Laurenz Albe wrote: > On Fri, 2021-01-15 at 16:13 +0700, Soni

Re: could not fsync file ""pg_wal/xlogtemp.23229"": Input/output error

On Fri, 2021-01-15 at 16:13 +0700, Soni M wrote: > We filled out the wal archive disk, and then those messages appear > > [...]PANIC,58030,"could not fsync file ""pg_wal/xlogtemp.3510"": Input/output > error" > > And now I cannot start postgres > > [...]PANIC,58030,"could not fsync file ""pg_wa

could not fsync file ""pg_wal/xlogtemp.23229"": Input/output error

Hi All, Postgres 11 on RHEL 7.9 We filled out the wal archive disk, and then those messages appear 2021-01-15 01:18:47.284 CST,"replicator","consprod",3510,"[local]",5fdebf22.db6,21,"SELECT",2020-12-19 21:04:02 CST,35/46792889,437317854,PANIC,58030,"could not fsync file ""pg_wal/xlogtemp.3510"": I