Re: Add os_page_num to pg_buffercache
От | Mircea Cadariu |
---|---|
Тема | Re: Add os_page_num to pg_buffercache |
Дата | |
Msg-id | e11896e2-9bc9-4994-ab1b-ccf6245d4b02@gmail.com обсуждение исходный текст |
Ответ на | Re: Add os_page_num to pg_buffercache (Bertrand Drouvot <bertranddrouvot.pg@gmail.com>) |
Ответы |
Re: Add os_page_num to pg_buffercache
|
Список | pgsql-hackers |
Hi,
Thanks for the update! I tried v5 and it returns the expected results on my laptop, same as before.
Just two further remarks for your consideration.
Let's capitalize the first letter here.+ <para> + number of OS memory page for this buffer + </para></entry>
In the existing pg_buffercache.sql there are sections similar to the above (SET ROLE pg_database_owner/pg_monitor ... RESET role), with a couple of different SELECT statements within. Should we rather add the above new SELECTs there, instead of in the new pg_buffercache_os_pages.sql?+-- Check that the functions / views can't be accessed by default. To avoid +-- having to create a dedicated user, use the pg_database_owner pseudo-role. +SET ROLE pg_database_owner; +SELECT count(*) > 0 FROM pg_buffercache_os_pages; +RESET role; + +-- Check that pg_monitor is allowed to query view / function +SET ROLE pg_monitor; +SELECT count(*) > 0 FROM pg_buffercache_os_pages; +RESET role;
Kind regards,
Mircea Cadariu
В списке pgsql-hackers по дате отправления: