Rakesh Kumar wrote:
> Is there a way to query dead rows (that is, rows which are dead and still not
> cleaned up by Vacuum)
> using SQL. I am asking this just as an academical question.
Sort of.
You can use heap_page_item_attrs() from the pageinspect contrib module to get
at the
data, but you
* Rakesh Kumar (rakeshkumar...@outlook.com) wrote:
> Is there a way to query dead rows (that is, rows which are dead and still not
> cleaned up by Vacuum) using SQL. I am asking this just as an academical
> question.
CREATE EXTENSION pageinspect;
https://www.postgresql.org/docs/9.6/static/page
Is there a way to query dead rows (that is, rows which are dead and still not
cleaned up by Vacuum) using SQL. I am asking this just as an academical
question.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
