From: | Loles <lolesft(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | No problem, only curiosity |
Date: | 2023-01-24 13:06:46 |
Message-ID: | CA+FWGK6U4RfPZqE=1RMTwU8ezqhJp8NBGuf_pErLF-RbtJ_FNA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hello community!
Does anyone know why I am getting a result less than 2 million rows in this
example?
postgres=# create table test_n_tup_live (id serial);
CREATE TABLE
postgres=# insert into test_n_tup_live select generate_series(1,1000000);
INSERT 0 1000000
postgres=# analyze test_n_tup_live ;
ANALYZE
postgres=# select n_live_tup, n_dead_tup from pg_stat_user_tables where
relname = 'test_n_tup_live';
n_live_tup | n_dead_tup
------------+------------
1000000 | 0
(1 fila)
postgres=# update test_n_tup_live set id = id + 1;
UPDATE 1000000
postgres=# insert into test_n_tup_live select generate_series(1,1000000);
INSERT 0 1000000
postgres=# select n_live_tup, n_dead_tup from pg_stat_user_tables where
relname = 'test_n_tup_live';
n_live_tup | n_dead_tup
------------+------------
2000000 | 1000000
(1 fila)
postgres=# vacuum test_n_tup_live;
VACUUM
postgres=# select n_live_tup, n_dead_tup from pg_stat_user_tables where
relname = 'test_n_tup_live';
n_live_tup | n_dead_tup
------------+------------
1999925 | 0
(1 fila)
Thanks!
From | Date | Subject | |
---|---|---|---|
Next Message | Erik Wienhold | 2023-01-24 13:51:55 | Re: No problem, only curiosity |
Previous Message | Scott Ribe | 2023-01-24 03:39:45 | Re: Postgres on L2ARC |