Re: [HACKERS] 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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
[HACKERS] 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. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
[HACKERS] 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-tp4257955p4257955.html Sent from the PostgreSQL - hackers mailing list archive at Nabble.com. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
