Re: [ADMIN] Who is causing all this i/o?

2011-06-19 Thread Craig James
On 6/17/11 11:51 AM, Shianmiin wrote: Tom Lane-2 wrote: What's not apparent however is why the stats collector is writing disk so much. 8.4 does have the logic change to not write stats out unless something is asking to see them. So either it's really pre-8.4, or you have a monitoring task

Re: [ADMIN] Who is causing all this i/o?

2011-06-19 Thread Tom Lane
Craig James craig_ja...@emolecules.com writes: On 6/17/11 11:51 AM, Shianmiin wrote: We have a PostgreSQL 9.0.4 on CentOs for performance testing and we are seeing the similar issue. we have a crazy setup it has 1 database with 1000 identical schemas. There are occasional I/O write storm of

Re: [ADMIN] Who is causing all this i/o?

2011-06-18 Thread Shianmiin
Tom Lane-2 wrote: What's not apparent however is why the stats collector is writing disk so much. 8.4 does have the logic change to not write stats out unless something is asking to see them. So either it's really pre-8.4, or you have a monitoring task that is constantly asking to see

Re: [ADMIN] Who is causing all this i/o?

2011-05-21 Thread Tom Lane
Craig James craig_ja...@emolecules.com writes: On 5/20/11 4:25 PM, Scott Marlowe wrote: On Fri, May 20, 2011 at 3:14 PM, Craig Jamescraig_ja...@emolecules.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

Re: [ADMIN] Who is causing all this i/o?

2011-05-21 Thread Craig James
On 5/21/11 8:11 AM, Tom Lane wrote: Craig Jamescraig_ja...@emolecules.com writes: On 5/20/11 4:25 PM, Scott Marlowe wrote: On Fri, May 20, 2011 at 3:14 PM, Craig Jamescraig_ja...@emolecules.com wrote: Our development server (PG 8.4.4 on Ubuntu server) is constantly doing something, and I

[ADMIN] Who is causing all this i/o?

2011-05-20 Thread Craig James
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

Re: [ADMIN] Who is causing all this i/o?

2011-05-20 Thread Joshua D. Drake
The other two servers are configured identically. If I diff the configuration files, the only difference is the IP addresses for the listen section. Can anyone tell me what's going on? Why is pgstat.stat being rewritten on this server constantly and not on the other two servers? Do you have

Re: [ADMIN] Who is causing all this i/o?

2011-05-20 Thread Craig James
On 5/20/11 3:38 PM, Joshua D. Drake wrote: The other two servers are configured identically. If I diff the configuration files, the only difference is the IP addresses for the listen section. Can anyone tell me what's going on? Why is pgstat.stat being rewritten on this server constantly and

Re: [ADMIN] Who is causing all this i/o?

2011-05-20 Thread Steve Crawford
On 05/20/2011 02:14 PM, Craig James 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

Re: [ADMIN] Who is causing all this i/o?

2011-05-20 Thread Scott Marlowe
On Fri, May 20, 2011 at 3:14 PM, Craig James craig_ja...@emolecules.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,

Re: [ADMIN] Who is causing all this i/o?

2011-05-20 Thread Craig James
On 5/20/11 4:25 PM, Scott Marlowe wrote: On Fri, May 20, 2011 at 3:14 PM, Craig Jamescraig_ja...@emolecules.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,

Re: [ADMIN] Who is causing all this i/o?

2011-05-20 Thread vequalsitimesz
I am tracking down possibly similar behavior on a production server and a colleague introduced me to Dstat. I am using it right now to try and track down the root of my problem. May or may not be helpful in figuring out exactly whats causing this and then on to figuring out to fix it.