Re: Postgres going very slow

2020-09-30 Thread Pavel Stehule
st 30. 9. 2020 v 10:06 odesílatel Olivier Leprêtre napsal: > Hi, > > > > > > We have a database which is getting very slow. Pgadmin 3 is alos very > slow, requiring more than 2 minutes to refresh the list of schemas > > Machine is a windows server 2016 with Intel Xeon 2,4Ghz, 24 Go Ram. > Postgre

Postgres going very slow

2020-09-30 Thread Olivier Leprêtre
Hi, We have a database which is getting very slow. Pgadmin 3 is alos very slow, requiring more than 2 minutes to refresh the list of schemas Machine is a windows server 2016 with Intel Xeon 2,4Ghz, 24 Go Ram. Postgres 9.6/32 bits Database contains 4000 schemas, each having 164 tables, 48 ind