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?
Euler Taveira de Oliveira
In response to
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2010-02-16 15:17:14|
|Subject: Re: OpenVMS? |
|Previous:||From: Alvaro Herrera||Date: 2010-02-16 14:36:32|
|Subject: Re: Explain buffers display units.|