Re: Read write performance check
Hi Veem, On Tue, Dec 19, 2023 at 7:36 AM veem v wrote: > 1)For write performance , the rows needs to be inserted from multiple > sessions at same time, with required random values as per the data types i.e. > Character, Number, date columns. And this needs to be tested for row by row > insert and batched insert. > > 2)For the read performance test , the table first has to be populated with > those ~100million rows. Then querying will happen on that table row by row > and batched way from the concurrent session. > > I am new to postgresql but mostly worked with Oracle, so I wanted to > understand if the above can be achieved by creating a simple procedure or > will a major effort be needed? And I saw a few blogs , pgbench to be used for > concurrency tests. Yes, you are right, pgbench with customized script is what you are looking for >I want to know if this will still work on Aurora postgresql from intellij >client worksheet. pgbench would work with aurora as with normal postgres, it is basically a shell script which connects to the database. Not sure if idea worksheet would help you in such case however, you can run it just from any machine with pgbench installed Best regards, Ilya -- Ilya Kosmodemiansky CEO, Founder Data Egret GmbH Your remote PostgreSQL DBA team T.: +49 6821 919 3297 i...@dataegret.com
Re: Question About PostgreSQL Extensibility
Hi Sepideh, > From: Sepideh Eidi > Date: Thu, Oct 12, 2023 at 2:35 PM > Subject: Question About PostgreSQL Extensibility > To: pgsql-general@lists.postgresql.org > We have some .net assemblies and in your documents, I didn’t find any support > for this type of files that is executable in DB or not. PostgreSQL doesn't support .net assemblies like SQL Server does. In Postgres you can certainly write stored procedures in different languages, for example in C, but I am not sure if it would solve your problem v. G., Ilya best regards, Ilya Kosmodemiansky, CEO, Data Egret GmbH Herrenstr. 1 A 2, Spiesen-Elversberg, Germany
Re: Code of Conduct plan
> On 14. Sep 2018, at 16:31, Ilya Kosmodemiansky wrote: > > > > > I could only heavily +1 this. I can get I can’t get of course, sorry for typo > from where comes the idea that community is only what happens just on > postgresql.org or just on some other channel community uses. > . > > >> >> -- >> Dave Page >> Blog: http://pgsnake.blogspot.com >> Twitter: @pgsnake >> >> EnterpriseDB UK: http://www.enterprisedb.com >> The Enterprise PostgreSQL Company
Re: Code of Conduct plan
> On 14. Sep 2018, at 16:17, Dave Page wrote: > > > The lists are just one of many different ways people in this community > interact. I could only heavily +1 this. I can get from where comes the idea that community is only what happens just on postgresql.org or just on some other channel community uses. Community is people who joined it and CoC supposed to apply even if people use analogue telephones. This is about communication, not about communication channels. > > -- > Dave Page > Blog: http://pgsnake.blogspot.com > Twitter: @pgsnake > > EnterpriseDB UK: http://www.enterprisedb.com > The Enterprise PostgreSQL Company
Re: Code of Conduct plan
On Fri, Sep 14, 2018 at 10:31 AM, Chris Travers wrote: > I really have to object to this addition: > "This Code is meant to cover all interaction between community members, > whether or not it takes place within postgresql.org infrastructure, so long > as there is not another Code of Conduct that takes precedence (such as a > conference's Code of Conduct)." > > That covers things like public twitter messages over live political > controversies which might not be personally directed. At least if one is > going to go that route, one ought to *also* include a safe harbor for > non-personally-directed discussions of philosophy, social issues, and > politics. Otherwise, I think this is asking for trouble. See, for example, > what happened with Opalgate and how this could be seen to encourage use of > this to silence political controversies unrelated to PostgreSQL. I think, this point has nothing to do with _correct_ discussions or public tweets. If one community member tweets publicly and in a way which abuses other community members, it is obvious CoC violation. It is hard to imagine healthy community if someone interacts with others correctly on the list or at a conference because the CoC stops him doing things which he will do on private capacity to the same people when CoC doesnt apply. If someone reports CoC violation just because other community member's _correct_ public tweet or whatsoever expressed different political/philosophical/religious views, this is a quite different story. I suppose CoC committee and/or Core team in this case should explain the reporter the purpose of CoC rather than automatically enforce it. > -- > Best Wishes, > Chris Travers > > Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor > lock-in. > http://www.efficito.com/learn_more