| From: | Sami Imseih <samimseih(at)gmail(dot)com> |
|---|---|
| To: | Erik Nordström <erik(at)timescale(dot)com> |
| Cc: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Relstats after VACUUM FULL and CLUSTER |
| Date: | 2025-05-22 20:42:33 |
| Message-ID: | CAA5RZ0scqdcVUtBCLWYWyPsYWvRbuiu_vHxetxN_HuhaDXiuvg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> In both cases, he recently dead tuples must be copied to the table or index, but
> they should not be counted towards reltuples. So, I think we need to fix this in
> heapam_relation_copy_for_cluster by probably subtracting
> tups_recently_dead from num_tuples ( which is the value set in
> pg_class.reltuples )
> after we process all the tuples, which looks like the best fix to me.
something like the attached.
--
Sami Imseih
Amazon Web Services (AWS)
| Attachment | Content-Type | Size |
|---|---|---|
| v1-0001-Correct-reltuples-count-after-a-VACUUM-CLUSTER-op.patch | application/octet-stream | 1.4 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2025-05-22 20:56:25 | Re: PATCH: jsonpath string methods: lower, upper, initcap, l/r/btrim, replace, split_part |
| Previous Message | Greg Sabino Mullane | 2025-05-22 20:19:53 | Re: [Util] Warn and Remove Invalid GUCs |