Re: writing a script to examine dead tuples

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