st 30. 9. 2020 v 10:06 odesílatel Olivier Leprêtre <o.lepre...@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 > > > <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient> > Garanti > sans virus. www.avast.com > <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient> > <#m_3938937459389730491_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> >
