From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Cc: | maxim(dot)boguk(at)gmail(dot)com |
Subject: | BUG #17205: pg_class.reltuples vakue wrong for brin indexes after vacuum (by many orders of magnitude) |
Date: | 2021-09-30 07:19:53 |
Message-ID: | 17205-42b1d8f131f0cf97@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 17205
Logged by: Maxim Boguk
Email address: maxim(dot)boguk(at)gmail(dot)com
PostgreSQL version: 13.4
Operating system: Linux
Description:
Hi,
pg_class.reltuples wrong by many order of magnitude after (auto)vacuum table
for brin indexes.
Analyze table set corrent value back, and following vacuum set it wrong
again (so correctness of value in production db depend on exact sequence of
autovacuu/autoanalyze runs).
Test case:
mboguk=# create table t (id integer);
CREATE TABLE
mboguk=# insert into t select id from generate_series(1, 10000000);
mboguk=# insert into t select id from generate_series(1, 10000000) as
g(id);
INSERT 0 10000000
mboguk=# create index t_brin on t using BRIN(id);
CREATE INDEX
mboguk=# vacuum ANALYZE t;
VACUUM
mboguk=# select reltuples from pg_class where relname='t_brin';
reltuples
--------------
9.999977e+06
(1 row)
mboguk=# vacuum t;
VACUUM
mboguk=# select reltuples from pg_class where relname='t_brin';
reltuples
-----------
345
(1 row)
mboguk=# analyze t;
ANALYZE
mboguk=# select reltuples from pg_class where relname='t_brin';
reltuples
--------------
9.999977e+06
(1 row)
mboguk=# vacuum t;
VACUUM
mboguk=# select reltuples from pg_class where relname='t_brin';
reltuples
-----------
345
(1 row)
And so on...
Tested on 12.* and 13.* versions.
Kind Regards,
Maksym
From | Date | Subject | |
---|---|---|---|
Next Message | Sébastien Caunes | 2021-09-30 09:03:14 | Bug report function to_date should reject HH24:MI:SS formatting options |
Previous Message | PG Bug reporting form | 2021-09-29 13:42:02 | BUG #17204: Import PostgreSQL view to ADO.NET Entity Framework Model |