Kevin Grittner wrote: > It sounds like you were counting the 8kB pages pushed from the > PostgreSQL cache to the OS cache, and I was counting the 1kB blocks > pushed from the OS cache to the RAID controller cache. By watching > vmstat results after pushing this to a more-or-less steady state, I > was probably picking up the results of autovacuum runs, but multiple > writes to a single page were often combined by the OS. If we match, > it's really just a coincidence.
I was counting WAL inserts actually, so "logical database operations". I left out "storage" items (filesystem actions), so it was mainly just catalog changes. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers