Hi ,
Me too have the same issue on PosgreSQL server. pgpgout/s is going high and
the same time didn't observe any swapping or memory pressure on the host.
Please refer below sar O/P.
12:00:01 PM pgpgin/s pgpgout/s fault/s majflt/s pgfree/s pgscank/s
pgscand/s pgsteal/s%vmeff
12:10:01 PM
On Monday, March 17, 2014, Kevin Goess kgo...@bepress.com wrote:
We had a big increase in load, iowait, and disk i/o on a dedicated
database host the other night.
Looking at the sar logs, the problem shows itself in a big increase in
pgpgout/s, which I believe is postgres paging out parts of
That makes sense, so updates to rows that are already in memory, either in
blocks in the kernel page cache or in blocks in the postgres cache, would
trigger writes but not reads. Thanks for the sanity check.
On Mon, Mar 17, 2014 at 11:04 PM, Jeff Janes jeff.ja...@gmail.com wrote:
On Monday,
We had a big increase in load, iowait, and disk i/o on a dedicated database
host the other night.
Looking at the sar logs, the problem shows itself in a big increase in
pgpgout/s, which I believe is postgres paging out parts of itself to disk?
02:15:01 AM pgpgin/s pgpgout/s fault/s majflt/s
Kevin Goess wrote
Can anybody help me understand what these statistics are suggesting,
what's
actually going on on this box/in postgresql? What is it writing to disk,
and why? Is it just writing out new/changed rows, or what?
Not a clue on the statistics but most likely you are seeing