Hi
Sometimes simple sql's like this takes a very long time "select count(*) from information_schema.tables;"
Other sql's not including system tables may work ok but login also takes a very long time.
The CPU load on the server is around 25%. There is no iowait.
This happens typically when we are running many functions in parallel creating many temp tables and unlogged tables I think.
Here is a slow one:
https://explain.depesz.com/s/tUt5
and here is fast one :
https://explain.depesz.com/s/yYG4
Here are my settings (the server has around 256 GB og memory) :
max_connections = 500
work_mem = 20MB
effective_cache_size = 96GB
effective_io_concurrency = 256
shared_buffers = 96GB
temp_buffers = 80MB
Any hints ?
Thanks .
Lars