Re: Postgres going very slow

st 30. 9. 2020 v 10:06 odesílatel Olivier Leprêtre <o(dot)lepretre(at)gmail(dot)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>
>