Re: Long Running Commits - Not Checkpoints

From: Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info>
To: Greg Smith <gsmith(at)gregsmith(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Long Running Commits - Not Checkpoints
Date: 2007-09-13 17:58:19
Message-ID: 1189706299.8624.43.camel@bnicholson-desktop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, 2007-09-13 at 12:12 -0400, Greg Smith wrote:
> Since you're probably not monitoring I/O waits and similar statistics on
> how the disk array's cache is being used, whether this is happening or not
> to you won't be obvious from what the operating system is reporting.

A sysadmin looked at cache usage on the disk array. The read cache is
being used heavily, and the write cache is not.

--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Michael Stone 2007-09-13 18:27:09 Re: SAN vs Internal Disks
Previous Message Gregory Stark 2007-09-13 17:46:42 Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1