Postgres Pro
Downloads
Home   >   mailing lists

pgstattuple_approx for toasted table - Mailing list pgsql-performance

From Mariel Cherkassky
Subject pgstattuple_approx for toasted table
Date
Msg-id CA+t6e1kTYbcQY4ohOS-OUvyu5T+=PTj_TZKvyMBeCS5V6V7ZFA@mail.gmail.com
Whole thread Raw
Responses Re: pgstattuple_approx for toasted table
List pgsql-performance
Tree view
Hi,
I was testing pgstattuple and I realized that pgstattuple is working on toasted table but pgstattuple_approx is raising the next error msg : 

ERROR:  "pg_toast_18292" is not a table or materialized view

ahm, is that because the pgstattuple_approx uses visibility map ? Can someone explain ? tnx.

pgsql-performance by date:

Previous
From: ROS Didier
Date:
Subject: RE: How to get the content of Bind variables
Next
From: Laurenz Albe
Date:
Subject: Re: pgstattuple_approx for toasted table