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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
