Re: Issue with pgstattuple on Sequences in PostgreSQL

2024-06-25 Thread Ayush Vatsa
> I agree it’s a documentation bug Thanks for confirmation, then maybe I can start a new thread in pgsql-hackers about this bug and I can myself create a patch for the same. > then the regression test should be fixed as well I will add regress test for sequences as well. We can remove *SEQUENCE*

Re: Issue with pgstattuple on Sequences in PostgreSQL

2024-06-24 Thread Tatsuo Ishii
> On Monday, June 24, 2024, Ayush Vatsa wrote: >> >> I was recently exploring the pgstattuple code directory and found this >> piece of code: https://github.com/postgres/postgres/blob/master/contrib/ >> pgstattuple/pgstattuple.c#L255-L259. >> >> It indicates that pgstattuple supports relations, to

Re: Issue with pgstattuple on Sequences in PostgreSQL

2024-06-24 Thread Adrian Klaver
On 6/24/24 04:09, Ayush Vatsa wrote: Hi PostgreSQL Community, I was recently exploring the pgstattuple code directory and found this piece of code: https://github.com/postgres/postgres/blob/master/contrib/pgstattuple/pgstattuple.c#L255-L259

Re: Issue with pgstattuple on Sequences in PostgreSQL

2024-06-24 Thread David G. Johnston
On Monday, June 24, 2024, Ayush Vatsa wrote: > > I was recently exploring the pgstattuple code directory and found this > piece of code: https://github.com/postgres/postgres/blob/master/contrib/ > pgstattuple/pgstattuple.c#L255-L259. > > It indicates that pgstattuple supports relations, toast tabl

Re: Issue with pgstattuple on Sequences in PostgreSQL

2024-06-24 Thread Ron Johnson
On Mon, Jun 24, 2024 at 7:09 AM Ayush Vatsa wrote: [snip] > How can one use pgstattuple on sequences? > Out of curiosity... *why*?

Re: Issue with pgstattuple on Sequences in PostgreSQL

2024-06-24 Thread Kashif Zeeshan
Hi I dont think Sequences are support, please refer to the following documentation. https://www.postgresql.org/docs/current/pgstattuple.html Regards Kashif Zeeshan On Mon, Jun 24, 2024 at 4:09 PM Ayush Vatsa wrote: > Hi PostgreSQL Community, > > I was recently exploring the pgstattuple code d

Issue with pgstattuple on Sequences in PostgreSQL

2024-06-24 Thread Ayush Vatsa
Hi PostgreSQL Community, I was recently exploring the pgstattuple code directory and found this piece of code: https://github.com/postgres/postgres/blob/master/contrib/pgstattuple/pgstattuple.c#L255-L259 . It indicates that pgstattuple supports relations, toast tables, materialized views, and seq