New answers tagged cache
1
vote
PostgreSQL: Is there any way to differentiate an actual Disk I/O from system cache hit?
Since the system cache belongs to the system, you mostly need to use system tools to assess it. vmstat being the preeminent one for me. Unless you have a lot of non-PostgreSQL related things also ...
Top 50 recent answers are included
Related Tags
cache × 176mysql × 58
sql-server × 40
postgresql × 34
performance × 31
memory × 18
innodb × 15
query-cache × 13
oracle × 10
mongodb × 10
optimization × 9
plan-cache × 8
buffer-pool × 8
query-performance × 7
postgresql-performance × 7
sql-server-2008-r2 × 6
execution-plan × 6
myisam × 6
sql-server-2012 × 5
index × 5
mariadb × 4
query × 4
architecture × 4
shared-buffers × 4
database-design × 3