From: Markus Schaber <schabi@logix-tt.com>
To: carlosreimer <carlosreimer@terra.com.br>
Cc: pgsql-performance <pgsql-performance@postgresql.org>
Subject: Re: Disk writes
Date: Mon, 07 Aug 2006 13:51:23 +0200
Message-ID: <44D7293B.20702@logix-tt.com> (raw)
In-Reply-To: <J33AN6$0933748F3F76B26B2DA40DD16BAC2950@terra.com.br>
References: <J33AN6$0933748F3F76B26B2DA40DD16BAC2950@terra.com.br>
Hi, Reimer,
carlosreimer wrote:
> There is some performance problems with the server and I discovered with
> vmstat tool that there is some process writing a lot of information in
> the disk subsystem.
[..]
> I could I discover who is sending so many data to the disks?
It could be something triggered by your crontab (updatedb comes in my
mind, or texpire from leafnode etc.).
Another idea would be that you have statement logging on, or something
else that produces lots of kernel or syslog messages[1], and your
syslogd is configured to sync() after every line...
HTH,
Markus
[1] We once had such a problem because an ill-compiled kernel having USB
verbose logging on...
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: schabi@logix-tt.com, carlosreimer@terra.com.br
Subject: Re: Disk writes
In-Reply-To: <44D7293B.20702@logix-tt.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox