Re: Who is causing all this i/o?

On Fri, May 20, 2011 at 3:14 PM, Craig James <craig_james(at)emolecules(dot)com> wrote:
> Our development server (PG 8.4.4 on Ubuntu server) is constantly doing
> something, and I can't figure out what.  The two production servers, which
> are essentially identical, don't show these symptoms.  In a nutshell, it's
> showing 10K blocks per second of data going out, all the time, and
> essentially zero blocks per second of input.
> After a lot of digging around, I found this in the /postgres/pg_stat_tmp
> directory.  If I list the directory including the i-nodes once every second,
> I find that a new 2MB file is being created roughly once every two seconds:

Have you got a lot of databases in your development environment? I
think that can sometimes cause a lot of pg_stat writes.