Jakub Ouhrabka escreveu: > These databases are archive databases, so there is no user activity - no > connected users. But the stats collector generates load - 20-40% of > modern 2.8GHz core all the time. > Did you try to set stats_temp_directory in a RAM based filesystem?
> Any clues what does it cause and how to investigate it? > OProfile? -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers