On Fri, May 20, 2011 at 3:14 PM, Craig James <craig_james@xxxxxxxxxxxxxx> 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. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
