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
