See and clear Postgres caches/buffers?

by

You can see what’s in the PostgreSQL buffer cache using the pg_buffercache module. I’ve done a presentation called “Inside the PostgreSQL Buffer Cache” that explains what you’re seeing, and I show some more complicated queries to help interpret that information that go along with that.

It’s also possible to look at the operating system cache too on some systems, see [pg_osmem.py] for one somewhat rough example.

There’s no way to clear the caches easily. On Linux you can stop the database server and use the drop_caches facility to clear the OS cache; be sure to heed the warning there to run sync first.

More Related Contents:

  1. How to reset postgres’ primary key sequence when it falls out of sync?
  2. PostgreSQL LIKE query performance variations
  3. How to import CSV file data into a PostgreSQL table
  4. Calculating and saving space in PostgreSQL
  5. Passing user id to PostgreSQL triggers
  6. PostgreSQL: ERROR: 42601: a column definition list is required for functions returning “record”
  7. I forgot the password I entered during postgres installation
  8. how to emulate “insert ignore” and “on duplicate key update” (sql merge) with postgresql?
  9. Does not using NULL in PostgreSQL still use a NULL bitmap in the header?
  10. How to generate the “create table” sql statement for an existing table in postgreSQL
  11. PostgreSQL: serial vs identity
  12. Postgres password authentication fails
  13. Generate series of dates – using date type as input
  14. Copy a few of the columns of a csv file into a table
  15. Postgres query to check a string is a number
  16. Returning from a function with OUT parameter
  17. ERROR: permission denied for relation tablename on Postgres while trying a SELECT as a readonly user
  18. How do you create a random string that’s suitable for a session ID in PostgreSQL?
  19. Joining Results from Two Separate Databases
  20. PL/pgSQL functions: How to return a normal table with multiple columns using an execute statement
  21. Update timestamp when row is updated in PostgreSQL
  22. Postgresql query array of objects in JSONB field
  23. Multicolumn index on 3 fields with heterogenous data types
  24. Select from a table variable
  25. PostgreSQL disable more output
  26. PostgreSQL array_agg order
  27. Postgres table column name restrictions?
  28. PostgreSQL jsonb, `?` and JDBC
  29. Syntax error at end of input in PostgreSQL
  30. Error when pushing data to Heroku: time zone displacement out of range

Leave a Comment