Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
1 9
Newest
 Teacher
Impact
~12k people reached

  • 0 posts edited
  • 0 helpful flags
  • 6 votes cast
Apr
13
comment How to calculate cache misses for PostgreSQL
In the cases you have a shared server (and you can't "reserve" almost entire memory to sharedbuffers), and you have high "disk hits" percentage, it means the database is "racing" against the others process by the memory use, and depending of the memory use (by the other processes), it probably is going to the disk to get tuples. So, in one case or the other, you have to avoid high "disk hits" percentages.
Apr
13
comment How to calculate cache misses for PostgreSQL
Yes! The "disk hits" value means that the tuple was not found in the database's sharedbuffers. But it doesn't necessarily mean that db went to disk to get the tuple. Sometimes it can get you a good clue, specially when you have a dedicated server, where almost entire memory is reserved to the sharedbuffers. In that case, if you have a high "disk hits" percentage, that surely means it's time to upgrade memory.
Jan
27
awarded  Teacher
Aug
19
answered the cache hit rate using pg_statio_user_tables
Aug
19
answered How to calculate cache misses for PostgreSQL
Aug
10
comment Performance hickups after Postgres 9.4 upgrade
@cherio: askubuntu.com/questions/597372/…
May
25
awarded  Notable Question
Mar
2
awarded  Tumbleweed
Feb
11
awarded  Popular Question
Sep
24
awarded  Autobiographer
Aug
4
awarded  Scholar
Aug
4
awarded  Supporter
Aug
4
accepted Efficient way to insert/update/delete table records from complex query in Postgres 9.x
Aug
4
awarded  Editor
Aug
4
revised Efficient way to insert/update/delete table records from complex query in Postgres 9.x
more information
Aug
3
asked Efficient way to insert/update/delete table records from complex query in Postgres 9.x
Mar
4
awarded  Popular Question
Sep
22
awarded  Student
Sep
20
asked Postgres: Server does not listen even listen_addresses is set to '*' in postgresql.conf