writing a script to examine dead tuples
Can anyone help me, i am trying to carry out an investigation
which involves accessing dead tuples within the postgresql.
I have been advised i could write a script that allows me to
examine dead tuples and am seeking advise on how to achieve this,
or pointers that can help me going in the right direction. I am
relatively new to this forum and postgresql and have been
assigned postgresql as a topic within my studies which as lead me to
creating a script to perform this task.
If anyone can help me i would be really grateful.
Thanks
Aaron
--
View this message in context: http://postgresql.1045698.n5.nabble.com/writing-a-script-to-examine-dead-tuples-tp4257956p4257956.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.
On 23.03.2011 01:36, aaronenabs wrote:
Can anyone help me, i am trying to carry out an investigation
which involves accessing dead tuples within the postgresql.I have been advised i could write a script that allows me to
examine dead tuples and am seeking advise on how to achieve this,
or pointers that can help me going in the right direction. I am
relatively new to this forum and postgresql and have been
assigned postgresql as a topic within my studies which as lead me to
creating a script to perform this task.If anyone can help me i would be really grateful.
One approach is to use the pageinspect contrib module or pg_filedump to
view the pages and tuples at a low level. Another is to modify
PostgreSQL sources to return dead tuples that would normally be skipped.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com