Thread: 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