Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres going very slow - Mailing list pgsql-general

From Pavel Stehule
Subject Re: Postgres going very slow
Date
Msg-id CAFj8pRDguxcOJ0P0TqtRKxNx56hxG42rorzObwQ7PgjVR1SN-Q@mail.gmail.com
Whole thread Raw
In response to Postgres going very slow  (Olivier Leprêtre <o.lepretre@gmail.com>)
List pgsql-general
Tree view


st 30. 9. 2020 v 10:06 odesílatel Olivier Leprêtre <o.lepretre@gmail.com> 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. Postgres 9.6/32 bits

Database contains 4000 schemas, each having 164 tables, 48 index. This generates 3,2 millions files in one folder (which could be an explanation..)

Searching to distribute datas across different disks, I looked at tablespace but as we work with schemas as a whole, it doesn’t seems to be adequate.

I tried to see if it as possible to distribute schemas on different folders but it doesn’t seems possible in the same database.

Would a solution be to create different databases which is possible but more complex to manage from a development point of view ?

Does going to postgres 64 could improve things ?

Any suggestions ?


You have 24GB RAM and you use 32bit Postgres. Sure, using 32 bit is pretty ineffective. Pgadmin will be every time slow if you have 4000 schemas - this design is not good for interactive tools that show all schemas.

Regards

Pavel

 

Thanks very much !

 

Olivier


Garanti sans virus. www.avast.com

pgsql-general by date:

Previous
From: Olivier Leprêtre
Date:
Subject: Postgres going very slow
Next
From: Devrim Gündüz
Date:
Subject: Re: Yum repository RPM behind release