| From: | Nathan Bossart <nathandbossart(at)gmail(dot)com> |
|---|---|
| To: | Ayush Vatsa <ayushvatsa1810(at)gmail(dot)com> |
| Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, michael(at)paquier(dot)xyz |
| Subject: | Re: Pgstattuple on Sequences: Seeking Community Feedback on Potential Patch |
| Date: | 2024-08-29 17:38:33 |
| Message-ID: | ZtCyGRmho3GJ3fHI@nathan |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, Aug 29, 2024 at 12:36:35PM -0500, Nathan Bossart wrote:
> +select * from pgstattuple('serial');
> + table_len | tuple_count | tuple_len | tuple_percent | dead_tuple_count | dead_tuple_len | dead_tuple_percent | free_space | free_percent
> +-----------+-------------+-----------+---------------+------------------+----------------+--------------------+------------+--------------
> + 8192 | 1 | 41 | 0.5 | 0 | 0 | 0 | 8104 | 98.93
> +(1 row)
>
> I'm concerned that some of this might be platform-dependent and make the
> test unstable. Perhaps we should just select count(*) here.
Sure enough, the CI testing for 32-bit is failing here [0].
--
nathan
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2024-08-29 18:17:06 | Re: proposal: schema variables |
| Previous Message | Nathan Bossart | 2024-08-29 17:36:35 | Re: Pgstattuple on Sequences: Seeking Community Feedback on Potential Patch |