Re: vacuumdb not letting me connect to db

2021-02-06 Thread Atul Kumar
Hi Gavan, Thanks for providing the details, I need more clarification on this as how should I analyze that what should be ideal no. of connections should we set to avoid IO overhead based on the available hardware resources. How to do this calculation ? Note: even during 300 threads, my RAM util

Re: vacuumdb not letting me connect to db

2021-02-06 Thread Gavan Schneider
On 6 Feb 2021, at 23:06, Atul Kumar wrote: Thanks for providing the details, I need more clarification on this as how should I analyze that what should be ideal no. of connections should we set to avoid IO overhead based on the available hardware resources. How to do this analysis properly is

Re: vacuumdb not letting me connect to db

2021-02-06 Thread Gmail
> On Feb 5, 2021, at 9:37 AM, Ron wrote: > >> On 2/5/21 10:22 AM, Rob Sargent wrote: >> >> >>> On 2/5/21 9:11 AM, Ron wrote: >>> Obviously... don't use 300 threads. >>> >> No, no Ron. Clearly the answer is more CPUs > > I hope you're being sarcastic. > > -- > Angular momentum makes the

Re: vacuumdb not letting me connect to db

2021-02-06 Thread Ron
On 2/6/21 6:06 AM, Atul Kumar wrote: Hi Gavan, Thanks for providing the details, I need more clarification on this as how should I analyze that what should be ideal no. of connections should we set to avoid IO overhead based on the available hardware resources. How to do this calculation ?

Should pgAdmin 3 be saved?

2021-02-06 Thread Gabriel Martin
Hello, I know that since the launch of pgAdmin 4 in 2016, pgAdmin has been using a web-based model, as announced as early as 2014. You only need to do a little research on the Web to understand all the reasons behind this choice, which I do not seek to question. However, I wonder if it would be r

Re: Should pgAdmin 3 be saved?

2021-02-06 Thread Tom Lane
Gabriel Martin writes: > Do you think there's a possibility that people could fix pgAdmin 3, even if > it means making a fork or whatever? You'd probably be better advised to ask this on the pgadmin project lists. Certainly, anybody who cares to fork and maintain pgAdmin 3 could do so. It's a ma

Re: Should pgAdmin 3 be saved?

2021-02-06 Thread Ian Lawrence Barwick
2021年2月7日(日) 4:07 Gabriel Martin : > Hello, > > I know that since the launch of pgAdmin 4 in 2016, pgAdmin has been using > a web-based model, as announced as early as 2014. You only need to do a > little research on the Web to understand all the reasons behind this > choice, which I do not seek t

Postgres NOSQL Benchmarking

2021-02-06 Thread Rushikesh socha
Hi, Any suggestion on how to do PostgreSQL benchmarking for Document Store database(Nosql/jsonb). I found this https://github.com/EnterpriseDB/pg_nosql_benchmark while searching google. Please advise if there anything latest available. Thanks.