Il 30/09/2013 16:41, Xenofon Papadopoulos ha scritto:
Should this ratio stay low even in the case of a write-heavy table?
Yes, in my opinion. Before data manipolation, database pages are moved on the shared buffer. heap_blks_read and heap_blks_hit are involved in those operations, not directly in data persistance on hard driver.
Giuseppe. -- Giuseppe Broccolo - 2ndQuadrant Italy PostgreSQL Training, Services and Support giuseppe.broccolo@xxxxxxxxxxxxxx | www.2ndQuadrant.it -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
