Types of blocks in the `pg_stat_statements`
Greetings.
I cannot get understanding about what different types of blocks means here:
http://www.postgresql.org/docs/current/interactive/pgstatstatements.html
I assume, that `shared` are blocks from the `shared_buffers`
and `temp` are blocks used by temporary files (absence of `dirtied` and
`hit` also speaks for this).
But what `local` blocks mean?
--
Victor Y. Yegorov
2016-04-25 15:06 GMT+02:00 Victor Yegorov <vyegorov@gmail.com>:
Greetings.
I cannot get understanding about what different types of blocks means here:
http://www.postgresql.org/docs/current/interactive/pgstatstatements.htmlI assume, that `shared` are blocks from the `shared_buffers`
and `temp` are blocks used by temporary files (absence of `dirtied` and
`hit` also speaks for this).But what `local` blocks mean?
This is for the local buffer for temporary objects (temporary tables and
indexes), which you can set the size with temp_buffers.
--
Guillaume.
http://blog.guillaume.lelarge.info
http://www.dalibo.com