Re: 答复: response time is very long in PG9.5.5 using psql or jdbc

=?gb2312?B?yq/Twrui?= <SHIYONGHU651(at)pingan(dot)com(dot)cn> writes:
> Yes,we have more than 500 thousand of objects,and the total size of the database is almost 10TB.Just as you said,we may need to reduce the objects number,or you have any better solution?

Hmph. I tried creating 500000 tables in a test database, and couldn't
detect any obvious performance problem in session startup. So there's
something very odd about your results. You might try looking at the
sizes of the system catalogs, e.g like
select pg_size_pretty(pg_total_relation_size('pg_attribute'));
(In my test database, pg_class is about 80MB and pg_attribute about
800MB.)

> And I also have a question that if the backend's internal caches of catalog is shared with other users or sessions?if the pgbouncer is usefull?

pgbouncer or some other connection pooler would help, yes. But I don't
think the underlying performance ought to be this bad to begin with.

regards, tom lane